Oracle Database Discussions

I try to create the statspack schema and I fail at the exact same spot. "ORA-00955: name is already used by an existing object." I drop the tablespace and user perfstat, along with the synonym, but I always end up with the same failure because it's created during the statspack installation.

I'm on 9i Sun Solaris




SQL> select OWNER, OBJECT_NAME from dba_objects where OBJECT_NAME ='STATS$SNAPSHOT_ID';

no rows selected


@${ORACLE_HOME}/rdbms/admin/spcreate.sql

create public synonym STATS$SNAPSHOT_ID for STATS$SNAPSHOT_ID
*
ERROR at line 1:
ORA-00955: name is already used by an existing object


SQL> select OWNER, OBJECT_NAME from dba_objects where OBJECT_NAME ='STATS$SNAPSHOT_ID';

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
PUBLIC
STATS$SNAPSHOT_ID

PERFSTAT
STATS$SNAPSHOT_ID



Any help would be appreciated.
Thanks