"NetComrade" <netcomradeNSPAM_at_bookexchange.net> wrote in message
news:4300fe3a.11431500_at_localhost...
> 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
@?/rdbms/admin/spdrop
Received on Mon Aug 15 2005 - 16:02:57 CDT
