Ana Sayfa > Oracle > ORACLE – Invalid objeleri toplu olarak compile etmek

ORACLE – Invalid objeleri toplu olarak compile etmek

Select 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;'
 From dba_objects
 where status = 'INVALID'
 and object_type in ('PACKAGE','FUNCTION','PROCEDURE','VIEW');

Both comments and pings are currently closed.

Yorumlar kapalı.