ORA-00955 on CREATE INDEX but name is not already used
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.
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.
0