Home » RDBMS Server » Server Administration » urgent- How to find invalidate procedures
urgent- How to find invalidate procedures [message #61712] 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 

Report message to a moderator

Re: urgent- How to find invalidate procedures [message #61713 is a reply to message #61712] Wed, 19 May 2004 21:32 Go to previous messageGo to next message
Anatol Ciolac
Messages: 113
Registered: December 2003
Senior Member
select owner,object_name,status
from dba_objects

Report message to a moderator

Re: urgent- How to find invalidate procedures [message #62010 is a reply to message #61713] Thu, 17 June 2004 09:35 Go to previous message
satish kumar
Messages: 10
Registered: March 2002
Junior Member
Hi,

Try with following query it displays all invalid database objects.

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS FROM DBA_OBJECTS WHERE STATUS <> 'VALID';

Report message to a moderator

Previous Topic: How to resize Temp tablespace ?
Next Topic: PMON FAILURE.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 14:17:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.