Monthly Archives: September 2012

How to compile all Oracle DB 11gR2 Invalid Objects

Login to SQLPlus Run the following statement: “@?/rdbms/admin/utlrp.sql” Advertisements

Posted in Oracle | Tagged , , , , , , | Leave a comment

How to query Oracle DB 11g for user account status

select USERNAME,ACCOUNT_STATUS from dba_users where USERNAME=’PUT_YOUR_USER_NAME_HERE’; Sample output: USERNAME                                    ACCOUNT_STATUS ——————————           ——————————– SADMIN           … Continue reading

Posted in Oracle | Tagged , , , | Leave a comment