You can run $ORACLE_HOME/rdbms/admin/utlrp.sql to compile all invalid packages in the database.

Sandeep


-----Original Message-----
From: Azelia Paul [mailto:[Email Address Removed] Friday, August 29, 2003 11:23 AM
To: LazyDBA.com Discussion
Subject: Invalid Packages



Hey Gang,

All my packages are invalid in Oracle. I got hint from a colleague that said by exporting the packages and then reimporting them could change the status from invalid to valid. Are there any ill affects from running this process that you'll know about.





_____

Do you Yahoo!?
The New <http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com> Yahoo! Search - Faster. Easier. Bingo.

Oracle LazyDBA home page