If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

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 ..

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 ...