Skip to Main Content

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!

Compile entire schema

484123Sep 22 2006 — edited Sep 22 2006
Hi folks,

I've got a gotcha!

couple of my views in the schema ABC are in invalid state. So, I resorted to the packaged procedure shown below.
DBMS_UTILITY.COMPILE_SCHEMA('ABC');

But still there is no change in the status of my views.
If I recompile each view, taking one at a time, then each view is regaining VALID status.

But there are something around hundred views in my schema. What should I do?
Doing one after one is insane, I suppose. It's absolutely time-taking and cumbersome as well.

Please advice me on this. It urgent!

Your favour'll be deeply appreciated.

Cheers, PCZ.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2006
Added on Sep 22 2006
8 comments
1,665 views