DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, January 9, 2017

Compile Invalid Objects in oracle


Compile Invalid Objects in oracle

SELECT    'alter '
       || DECODE (object_type, 'PACKAGE BODY', 'PACKAGE', object_type)
       || ' '
       || owner
       || '.'
       || object_name
       || ' compile;'
  FROM dba_objects
 WHERE status = 'INVALID'
/

No comments: