Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> completely get rid of perfstat user
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
Received on Mon Aug 15 2005 - 15:42:45 CDT
![]() |
![]() |