statspack issue - Page 2 Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: statspack issue

  1. #11
    Join Date
    Jun 2000
    Madrid, Spain
    Originally posted by fraze
    I've also found that if you want to reinstall statspack you need to comment out whenever sqlerror exit; out of spcusr.sql (called by spcreate.sql) because the drop script doesnt drop the x$ views and synonyms so falls over when you try and re-create them

    is that 8i? I just created and drop a statspack user yesterday in 9i and it does drop the synonyms

  2. #12
    Join Date
    Nov 2000
    Birmingham, UK
    Yep - I hit it in 8i - never tried in 9i - could've just been me though - cant remeber the steps I took to de-install it... MMmmmmm after looking properly at the scripts I take it all back - got a funny feeling the last time I deintalled it I just dropped the perfstat user cascade and tried to re-install it - probably should have used spdrop!!!

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