DB Version 12.1.02 EE
I am doing import export schemas and while import many schemas . Import failed with ORA-00955 error.
import log:
+++++++++++++++++++++++++++++++++++
ORA-39083: Object type CONSTRAINT:"RQF"."CV_ACCESS_AUD_UK2" failed to create with error:
ORA-00955: name is already used by an existing object
Failing sql is:
ALTER TABLE "RQF"."CV_ACCESS_AUD" ADD CONSTRAINT "CV_ACCESS_AUD_UK2" UNIQUE ("CA_CV_ID", "CA_GROUP_UID", "CA_EMPLOYEE_NO", "AUD_UID") USING INDEX (CREATE UNIQUE INDEX "RQF"."CV_ACCESS_AUD_UK1" ON "RQF_CV"."CV_ACCESS_AUD" ("CA_CV_ID", "CA_EMPLOYEE_NO", "CA_GROUP_UID", "AUD_UID") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 10
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
I checked with import DB. This index(CV_ACCESS_AUD_UK1) already in the DB under RQF schema and that was created through import automatically.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Not sure why This happen.
Can any one explain it.
Ashwan