This content has been marked as final. Show 3 replies
I believe this will work :
You don't have to do anything to synonyms. When you touch them they become valid.
SET heading off; SET feedback off; SET echo off; SET lines 999; SPOOL invalid.sql SELECT 'ALTER ' || object_type || ' ' || owner || '.' || object_name || ' COMPILE;' FROM dba_objects WHERE status = 'INVALID' AND owner in ('INFAI2X_RO') AND object_type IN ('VIEW'); SPOOL off; SET heading on; SET feedback on; SET echo on; @invalid.sql