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!

PL/SQL Developer: SQL of Compile Invalid Objects Tool Option

718082Aug 19 2009 — edited Aug 19 2009
Hi all,

I have a script that updates on daily basis my database schema with all the core changes done on the database objects within that day.
At the end of the script, i need to recompile the invalid database objects in order to bring my schema on a stable phase.

I would like to put in the script the same command that the PL/SQL Developer Compile Invalid Objects tool is using.
Does anyone know the exact command that is executed upon pressing the execute button?

Many thanks and Regards,
Mina
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2009
Added on Aug 19 2009
6 comments
2,240 views