Oracle Database Discussions

Hi,

I am trying simple data pump export import of a 20Gb schema in oracle 11.2.0.1 on linux.
During import it gives me below warnings that object already exists( these are constraints).

I have tried doing full DP export import..then I tried to import tables first and then constraints and indexes but still it gives same error.
Then I tried to search below object names( like TTSMC_ID_IDX,TTSQLMOD_PRI_KEY...etc) in dba_objects/dba_constraints/dba_synonyms/dba_indexes but I am not finding same object in target database.

Then I tried running one statement manually from import log manually by changing name from TTSMC_ID_IDX to TTSMC_ID_IDX1. The statement executed fine.
I know I can change name as these are just constraints/indexes but it's a third party database and I prefer not to change anything. Also I am curious to know what is happening.



ORA-31684: Object type INDEX:"TTSERVER"."TTSMC_ID_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQLMOD_PRI_KEY" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSMC_MS_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSMC_SC_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_PRI_KEY" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_HK_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_MSK_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTDETAIL_MS_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_SQL_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_USER_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_LOGIN_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTSQL_SCHEMA_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTDETAIL_PRI_KEY" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTTA_USAGE_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTTA_USAGE_PK" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTTA_USAGE_UNQ" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTCO_USAGE_UNQ" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTCO_USAGE_PK" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTCO_USAGE_IDX" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTLI_USAGE_PK" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTLI_USAGE_UNQ" already exists
ORA-31684: Object type INDEX:"TTSERVER"."TTLI_USAGE_IDX" already exists
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "TTSERVER"."TTSQL_MODEL_CORR" ADD CONSTRAINT "TTSQLMOD_PRI_KEY" PRIMARY KEY ("SQL_ID", "SCHEMA_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT
CELL_FLASH_CACHE DEFAULT) TABLESPACE "TTSERVER_DATA" ENABLE
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "TTSERVER"."TTSQL_TEXT" ADD CONSTRAINT "TTSQL_PRI_KEY" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1048576
NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TTSERVER_DATA" ENABLE
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "TTSERVER"."TTANALYZED_DETAIL" ADD CONSTRAINT "TTDETAIL_PRI_KEY" PRIMARY KEY ("TSERVER_NAME", "CONNECTION_NUMBER", "TRANSACTION_ID") USING INDEX P
CTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_
POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TA
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "TTSERVER"."TTMODEL_TA_USAGE" ADD CONSTRAINT "TTTA_USAGE_PK" PRIMARY KEY ("MODEL_SET_KEY", "OBJECT_ID", "SEQ_NUM") USING INDEX PCTFREE 10 INITRANS
2 MAXTRANS 255 STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH
CACHE DEFAULT CELLFLASH_CACHE DEFAULT) TABLESPACE "TTSERVER
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "TTSERVER"."TTMODEL_TA_USAGE" ADD CONSTRAINT "TTTA_USAGE_UNQ" UNIQUE ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 104857
6 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT
) TABLESPACE "TTSERVER_DATA" ENABLE
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-00955: name is already used by an existing object