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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.