Oracle Database Discussions

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!

Recompile invalid objects

Karan KukrejaNov 25 2010 — edited Nov 25 2010

Hi all ,

Good day..

I am looking for a SQL script that I can add to my import script which will recompile all the invalid objects once the import is complete. Since i am using schema level import , some of the objects (functions/packages) become invalid and need to validated using PL/SQL developer or TOAD.

oracle version 11.1.0.7, OS : solaris SPARC 64 bit.

Please share if you have such a script that can help me in this task.

thanks

- kk :)

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 23 2010

Added on Nov 25 2010

#general-database-discussions

3 comments

2,351 views