Database Administration (MOSC)

MOSC Banner

ORA-00955 on CREATE INDEX but name is not already used

edited Aug 20, 2009 6:08AM in Database Administration (MOSC) 9 commentsAnswered
Hi all.
We are using Oracle 11.1.0.7.0 on an AIX Server.

I am setting up multiple similiar Oracle-Schemata using SQLPLUS and SQLLDR

after creating tablespaces,schemas and tables and loading all data I try to create indexes on the filled tables through SQLPLUS with normal create index statements like

CREATE INDEX SVA.I_LEISTUNG221_1 ON SVA.LEISTUNG221
(FPKZ, KRL) GLOBAL
LOGGING
TABLESPACE SVA_INDEX_LEISTUNG221
PCTFREE    10
PARALLEL 2;

all worked fine but suddenly some of the indizes (like the one i posted above) failed with ORA-00955 (Object name already in use).

But In schema SVA no OBJECT with name "I_LEISTUNG221_1" exists.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center