I do have a question .. What will happen if I rerun catproc.sql .. My guess is it will drop the existing objects owned by sys and will recreate it . I ran the sql while the database is open and when heavy activity is going on .. All my sys triggers are got invalid . Why it is happened like that ..Any advise to bring back my invalid sys triggers to valid ..
You don't need to run the entire script if you don't want to. Edit catproc.sql using sqlplus and just run the script of the
Triggers missing after login to the database as "SYS"
Thanks ..and I just want to make sure that nothing goes wrong with catalog view's and sys triggers if I rerun the catproc.sql while the other user's are connecting to this database . Since it 24/7 database .. I can't shutdown this database and logon to it exclusively and recreate the catlogs ...