Recompilar objetos invalidos
6 views
Skip to first unread message
Wilson Barraza
Jan 22, 2007, 2:11:29 PM1/22/07
to Adminitración Oracle
set head off
spool c:\inv.lst
SELECT 'ALTER '||decode(object_type,'PACKAGE
BODY','PACKAGE',object_type)||' '|| object_name||' '||'COMPILE '
||DECODE(object_type, 'PACKAGE
BODY','BODY','PACKAGE','PACKAGE','')||';'
FROM user_objects
WHERE status='INVALID'
/
spool c:\inv.lst
SELECT 'ALTER '||decode(object_type,'PACKAGE
BODY','PACKAGE',object_type)||' '|| object_name||' '||'COMPILE '
||DECODE(object_type, 'PACKAGE
BODY','BODY','PACKAGE','PACKAGE','')||';'
FROM user_objects
WHERE status='INVALID'
/
spool off
@c:\inv.lst
Reply all
Reply to author
Forward
0 new messages