Oracle DB FAQs
Monday, 4 November 2013
Query to get Invalid Objects in Oracle Schema
SQL> SELECT SUBSTR(object_name,1,20) "Object",
OBJECT_TYPE "OType",
TO_CHAR(LAST_DDL_TIME, 'DD-MON-YYYY HH24:MI:SS') "Change Date",
status
FROM USER_OBJECTS
WHERE STATUS <> 'VALID';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment