Lists all invalid objects in the database

by

This script share the details of all invalid objects in oracle database.

COLUMN owner FORMAT A30
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;

Displays temp usage for all session currently using temp space

Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.
Please comment here for your any query related to above post. You can email me on : oracleocpworld@gmail.com.

Leave a Comment