What will happen if I rerun catproc.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What will happen if I rerun catproc.sql

  1. #1
    Join Date
    Aug 2001
    Posts
    267
    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 ..

    Raghu

  2. #2
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87

    Catproc.sql

    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"

    Cheers!!!!

  3. #3
    Join Date
    Aug 2001
    Posts
    267
    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 ...
    Raghu

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width