Invalid Objects Query


SQL> select count(*) from dba_objects where status=’INVALID’;

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;


Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."