Monthly Archives: September 2012

How to compile all Oracle DB 11gR2 Invalid Objects

Posted on September 19, 2012 by SoCRaT

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

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

How to query Oracle DB 11g for user account status

Posted on September 4, 2012 by SoCRaT

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