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
the question is why they are invalid. But you can also start sqlplus on the database server as sys and type @?/rdbms/admin/utlrp
This will try to compile all invalid objects in the correct order.
Why are you responding to mseberg? I'm pretty certain he knows what the question is.
If you have feedback for the OP you should use the 'reply' button of OP's post.