Home » RDBMS Server » Performance Tuning » urgent- How to find invalid objects in oracle
urgent- How to find invalid objects in oracle [message #65152] Wed, 19 May 2004 18:38 Go to next message
Raghu
Messages: 31
Registered: September 2000
Member
Hi all!

   In my dtabase there are around 575 procedures.  I want to know how to find the invalid procedures among the existing. my dtabse is running on 2000server, oracle 8i  or else How find invalid objects in Oracle 8i

 

  thanks in advance

raghu
Re: urgent- How to find invalid objects in oracle [message #65153 is a reply to message #65152] Wed, 19 May 2004 22:01 Go to previous messageGo to next message
Krishnan
Messages: 18
Registered: October 2000
Junior Member
I think this should help you;
select * from user_objects
where object_type='PROCEDURE'
and status ='INVALID'

Regards,
Krishnan
Re: urgent- How to find invalid objects in oracle [message #65212 is a reply to message #65152] Tue, 15 June 2004 03:45 Go to previous message
matkien
Messages: 5
Registered: May 2002
Junior Member
select *
from user_objects
where status = 'INVALID'
Previous Topic: Regarding Query Tuning
Next Topic: Oracle SQL statements Case sensitive for Performance?
Goto Forum:
  


Current Time: Thu Mar 28 18:04:31 CDT 2024