completely get rid of perfstat user

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 15 Aug 2005 20:42:45 GMT
Message-ID: <4300fe3a.11431500@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 Received on Mon Aug 15 2005 - 15:42:45 CDT