Compile entire schema
484123Sep 22 2006 — edited Sep 22 2006Hi 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.