Oracle:instance invalides objects

De Lowgeek wiki

Bdd.png

Lister tous les objets invalides d'une instance Oracle

<syntaxhighlight lang="sql"> SELECT OWNER,

      OBJECT_TYPE,
      OBJECT_NAME,
      CREATED,
      STATUS,
      LAST_DDL_TIME
 FROM DBA_OBJECTS
WHERE STATUS='INVALID'
ORDER BY OWNER, OBJECT_NAME;

</syntaxhighlight>