SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

i want to recompile all invalid objects.But i dun knw wht the schema is

user8731258Oct 11 2010 — edited Oct 11 2010

hi..i want to recompile all invalid objects using DBMS_UTILITY.compile_schema(schema =>'');
But i dun know what the schema is.Is it possible to set the schema name through the session variables??

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2010

Added on Oct 11 2010

4 comments

193 views