I had a cron job scheduled to do this...
okay, I hate plugging books on this list (if they are mine I mean), and
I will happily provide the script for free, but it IS documented, with
the script on the CD in the book SQL PL/SQL Annotated Archives.
If you want the script to generate the sql to
: RE: invalid
procedure/trigger
Hi
Shuan,
Have
known the Third party of oracle from Quest Software , The product name is
TOAD. Using this application you can check the valid or invlaid the procedure
and also you can recompile it. Or, you can create the script to check
function
: '[EMAIL PROTECTED]'Subject: RE: invalid
procedure/trigger
Depending on the interdependencies among the modules, youMAY have
to run the creator scriptand the created script several times before all
the objects become 'VALID'.
I
think it would be better to write a PL/SQL scriptwhich
Check
the status column of user_objects for procedures etc.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 9:59
PMTo: Multiple recipients of list ORACLE-LSubject:
invalid procedure/trigger
Dear all DBAs,
Is there
Hi,
You could consider scheduling a job which queries all_objects, based on
object_type and status to locate the invalid objects. The job could then
create some dynamic SQL to recompile them. I'm not so sure if you could
place a trigger anywhere to do this automatically but you could schedule
Hi
Shuan,
Have
known the Third party of oracle from Quest Software , The product name is TOAD.
Using this application you can check the valid or invlaid the procedure and also
you can recompile it. Or, you can create the script to check function,
procedure,view,and trigger from table
To check for invalid objects:
select object_type, owner, object_name
from dba_objectswhere object_type in ('PACKAGE','PACKAGE
BODY','PROCEDURE','FUNCTION') AND OWNER IN
('MyOwner1','MyOwner2') and status = 'INVALID' order
by
decode(object_type,'PACKAGE',0,
'PACKAGE
BODY',1,
'FUNCTION',
I like the donation jar idea. Someone owes me $5 from work today already.
:)
-Original Message-
Sent: Wednesday, January 08, 2003 11:19 PM
To: Multiple recipients of list ORACLE-L
Hi,
You could consider scheduling a job which queries all_objects, based on
object_type and status to
Thanks to all.
It works!
Have a nice day.
- Original Message -
From:
Djordje
Jankovic
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 11:33
AM
Subject: Re: invalid
procedure/trigger
To check for invalid objects:
select