Perfect timing. I was putting togeter some recompile scripts for work.
Here is a modified one that can be used for views. With a few changes it
can be used to recompile any invalid object.
1. Create a cursor on the Catalog Table ALL_OBJECTS where OBJECT_TYPE =
'VIEW' and STATUS = 'INVALID'.
Joe;
For those of us not on
8.1.7 ..
Besides .. I had no idea that
was there.
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 14, 2001 10:55
AMTo: [EMAIL PROTECTED]; [EMAIL PROTECTED]Subject: RE:
Invalid views
Why not just use
Why not just use(8.1.7 thing)
$ORACLE_HOME/rdbms/admin/utlrp.sql
joe
[EMAIL PROTECTED] 06/14/01 11:47AM Perfect
timing. I was putting togeter some recompile scripts for work.Here is
a modified one that can be used for views. With a few changes
itcan be used to recompile any invalid