Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

STATSPACK - ORA-01920

538299Jul 13 2007 — edited Jul 13 2007

Hi,

SQL> @?/rdbms/admin/spcreate
Choose the PERFSTAT user's password [password]
Choose the Default tablespace for the PERFSTAT user [PERFSTAT]<--I had to create it
Choose the Temporary tablespace for the PERFSTAT user [TEMP]

Using tablespace TEMP as PERFSTAT temporary tablespace.

... Creating PERFSTAT user
create user perfstat
*
ERROR at line 1:
ORA-01920: user name 'PERFSTAT' conflicts with another user or role name

How to proceed? does it mean that statspack is installed? should I remove 'PERFSTAT' user?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2007

Added on Jul 13 2007

#general-database-discussions

3 comments

1,057 views