Oracle Compile Invalid Object – PLS-00201: identifier ‘DBMS_LOCK’ must be declared
March 29th, 2013
3 comments
Just finished importing a complete oracle database dump with impdp.
Immediately after the import I checked for invalid objects and of course some were present.
In order to get the complete list of schema objects that were invalid I ran the following:
Categories: Oracle