ORA-02327 when creating index
Hi,I exported a schema from one database and imported it into a new schema in another database. During the import the schema got created, all the objects imported fine, except one index. The error message:
ORA-39083: Object type INDEX failed to create with error:
ORA-20000: Oracle Text error:
DRG-52204: error while registering index
DRG-10507: duplicate index name: FT_IDCCOLL2, owner: DEV_OCS
Failing sql is:
BEGIN
ctxsys.driimp.create_index('FT_IDCCOLL2','IDCCOLL2',USER,
'DID','2','DDOCFULLTEXT','113',
'0','13942','8130','13943',
NULL, 'DFULLTEXTFORMAT','DFULLTEXTCHARSET',0,NULL, 'ON COMMIT','12582912',NULL, NULL );
ORA-20000: Oracle Text error:
DRG-52204: error while registering index
DRG-10507: duplicate index name: FT_IDCCOLL2, owner: DEV_OCS
Failing sql is:
BEGIN
ctxsys.driimp.create_index('FT_IDCCOLL2','IDCCOLL2',USER,
'DID','2','DDOCFULLTEXT','113',
'0','13942','8130','13943',
NULL, 'DFULLTEXTFORMAT','DFULLTEXTCHARSET',0,NULL, 'ON COMMIT','12582912',NULL, NULL );
0