Fix Invalid Objects on AWS RDS 
--
-- Fix Invalid Objects on AWS RDS where you do not have access to utlrp.sql.
--
 
SET LINES 180
SET ECHO OFF
SET HEA OFF
SET FEEDBACK OFF
 
SPOOL /tmp/fixinvalid.sql
select distinct('exec SYS.UTL_RECOMP.RECOMP_SERIAL('''||owner||''');') from dba_objects WHERE status = 'INVALID'
/
SPOOL OFF
 
SET FEEDBACK ON
SET ECHO ON
@/tmp/fixinvalid.sql

awsinvalidobjectsrds
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License