Can non-DBAs run utlrp.sql?
-----Original Message-----
From: Sandeep Dubey [mailto:sandeep.[Email Address Removed] Sent: Friday, August 29, 2003 12:17 PM
To: LazyDBA.com Discussion
Subject: RE: Invalid Packages


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] Sent: 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 Yahoo! Search - Faster. Easier. Bingo.
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
Oracle LazyDBA home page