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