HIRE ORACLE DBA IN ABU DHABI
ORACLE DBA JOBS DUBAI
Tuesday, June 3, 2014
invalid_objects script in oracle 10g
-- -----------------------------------------------------------------------------------
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment