Re: completely get rid of perfstat user

NetComrade wrote:
> All,
>
> Is there are a way to completely remove perfstat from the database
> (w/o looking through each create script)? (9.2.0.7)
> For whatever reason, something keeps not being incremented, and we
> get the following error on executing the perfstat job.
>
> ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK)
> violated ORA-06512: at "PERFSTAT.STATSPACK", line 1361
> ORA-06512: at "PERFSTAT.STATSPACK", line 2471
> ORA-06512: at "PERFSTAT.STATSPACK", line 91
> ORA-06512: at line 1
>
> We've tried dropping the user and then recreating it, but it doesn't
> seem to help (I believe there are other objects being created
> elsewhere that perfstat relies on)
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email

I haven't a system available right now, so I don't know the exact name and location, but there should be a Statspack supplied sql-script that does just what you want.
(Something like spdel.sql or spdrop.sql)

HTH,

-- 
Jeroen