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!

Need help with DBMS_UTILITY.compile_schema

407338Sep 3 2010 — edited Sep 3 2010

Hi gurus,
Please help me with the use of DBMS_UTILITY.compile_schema.
When I exec DBMS_UTILITY.compile_schema (schema_name, false) in SQL*PLus, it does not validate any of the invalid objects but it does not generate any errors either. If I exec DBMS_UTILITY.compile_schema (schema_name, true), it invalidate almost all the objects for the schema! I am in Oracle 10g R2 910.2.0.3.0) enterprise edition. I checked the Oracle doc about DBMS_UTILITY.compile_schema and did not see anything special about it.
What is wrong?
Any help is appreciated! Because of this problem, I have to use JDev to recompile each invalid objects manually.
Thank you.

Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2010

Added on Sep 3 2010

6 comments

2,454 views