Home » RDBMS Server » Server Administration » error installing STATSPACK
error installing STATSPACK [message #156690] Fri, 27 January 2006 01:46 Go to next message
jprakashm
Messages: 9
Registered: January 2006
Junior Member

Hi,

I'm getting the following error, while trying to install STATSPACK in Oracle 9i server (running in W2K3 server):

=====================================================

Using TOOLS tablespace to store Statspack objects

... Creating STATS$SNAPSHOT_ID Sequence
create sequence STATS$SNAPSHOT_ID
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

=====================================================

Please help.

Regards,
Jayaprakash

Report message to a moderator

Re: error installing STATSPACK [message #156701 is a reply to message #156690] Fri, 27 January 2006 03:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
try using spdrop.sql. clean the statspack environment and startover again.

Report message to a moderator

Re: error installing STATSPACK [message #156702 is a reply to message #156690] Fri, 27 January 2006 03:48 Go to previous message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
Run "spdrop.sql" to remove the statspack objects and user before installing it.

Report message to a moderator

Previous Topic: datawearhousing
Next Topic: Index Space Utilization
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 25 10:49:23 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.