Friday, 23 May 2014

List of Invalid Objects in Oracle


set heading off
set feedback off
set echo off
set linesize 999

SELECT  OWNER, OBJECT_NAME, OBJECT_TYPE, STATUS
FROM    DBA_OBJECTS
WHERE   STATUS = 'INVALID'
ORDER BY OWNER, OBJECT_TYPE, OBJECT_NAME;

set heading on
set feedback on
set echo on

No comments:

Post a Comment