version: 11.2.0.4.0
OS: solaris 11
Hello Guys, i am trying to a metadata only import of tables into a table and i am getting the following errors.
ORA-39083: Object type TABLE:"PRDMMISENC"."AD_CLAIM_HEADER" failed to create with error:
ORA-02261: such unique or primary key already exists in the table
Failing sql is:
CREATE TABLE "PRDMMISENC"."AD_CLAIM_HEADER" ("CLAIM_HEADER_SID" NUMBER(30,0), "CLM_SOURCE_CODE" VARCHAR2(2 BYTE), "TCN" VARCHAR2(21 BYTE) NOT NULL ENABLE, "PARENT_TCN" VARCHAR2(21 BYTE), "ORIGINAL_TCN" VARCHAR2(21 BYTE) NOT NULL ENABLE, "FROM_SERVICE_DATE" DATE, "TO_SERVICE_DATE" DATE, "SPECIAL_PROGRAM_LKPCD" VARCHAR2(2 BYTE), "SERVICE_ATH
ORA-39083: Object type TABLE:"PRDMMISENC"."AD_CLM_HDR_OCCURRENCE_DETAIL" failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE TABLE "PRDMMISENC"."AD_CLM_HDR_OCCURRENCE_DETAIL" ("CLM_HDR_OCCURRENCE_DETAIL_SID" NUMBER(30,0) NOT NULL ENABLE, "CLAIM_HEADER_SID" NUMBER(30,0) NOT NULL ENABLE, "CLM_OCCURRENCE_AND_SPAN_CID" VARCHAR2(2 BYTE) NOT NULL ENABLE, "FROM_DATE" DATE, "TO_DATE" DATE, "CREATED_BY" NUMBER(15,0) NOT NULL ENABLE, "CREATED_DATE" DATE NOT NULL ENABLE, "MODIFI
So, the tables i am trying to import do not exist in the target database, but why am i getting ORA-02261 error or the ORA-00942? the export of the metadata went fine. i even dropped and recreated the schema in the target database in which i am trying to import the table's metadata. Here is the weird part, the non-partition table's metadata is getting imported fine, it is the partitioned table's data with with I am facing the errors. Anybody faced this issue before with impdp?
parfile:
directory=<directory_name>
dumpfile=cld_ec_gg_enc_mdata.dmp
logfile=imp_cld_ec_gg_enc_mdata.log
content=metadata_only
transform=segment_attributes:n,oid:n
tables=<table_list>
remap_schema=<source_schema>:<target_schema>
remap_tablespace=<source_tablespace>:<target_tablespace>