statspack issue - Page 2
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
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Location
    Birmingham, UK
    Posts
    360
    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