Monday 11 May 2015

CHECK ALL INVALID OBJECTS IN A SCHEMA :

COLUMN object_name FORMAT A30
SELECT owner,
       object_type,
       object_name,
       status
FROM   dba_objects
WHERE  status = 'INVALID'
ORDER BY owner, object_type, object_name;

No comments:

Post a Comment