Re: Creating perfstat - statspack fails

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 23 Oct 2004 12:35:43 +1000
Message-Id: <4179c374$0$14206$afc38c87@news.optusnet.com.au>

Maria wrote:

> Hi all
>
> I use to have statspack installed up an running then applied oracle
> patch from 8.1.7.0 to 8.1.7.4.0 statspack stop working dont know why.
> Then droped the perfstat user and tried once again to recreate, now I
> get this error message when I run the following
> sqlplus internal
> sql>@?/rdbms/admin/spcreate
> Grant succeeded.
>
> create view X_$KCBFWAIT as select * from X$KCBFWAIT
> *
> ERROR at line 1:
> ORA-00955: name is already used by an existing object
>
> I dont know what to do? this is 8i on solaris 5.8, since this is
> production I dont want to play tooo much since that view is under sys
> user id
>
> Thank you
> maria

To uninstall statspack, you should run $ORACLE_HOME/rdbms/admin/spdrop.sql

Then you can re-install.

Regards
HJR Received on Fri Oct 22 2004 - 21:35:43 CDT