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