Hi Team,
I have a requirement to import data from table A into table B in a different schema;
Can I use imdp to append the data from one schema table to a different table in a different schema?
The tables have the same columns.
Can I use table_remap to do this?
CREATE TABLE "CASUSER"."CAS_RECONCILIATIONDETAIL"
( "ID" NUMBER NOT NULL ENABLE,
"REQUESTID" NUMBER NOT NULL ENABLE,
"FILEID" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"INSERTDATE" TIMESTAMP (6) NOT NULL ENABLE,
"LASTMODIFIEDDATE" TIMESTAMP (6) NOT NULL ENABLE,
"STATUS" VARCHAR2(4000 BYTE),
"RETRIEVABLE" NUMBER(1,0)
)
To append to this table:
CREATE TABLE "AIC"."AIC_CAS_RECONCILIATIONDETAIL"
( "ID" NUMBER NOT NULL ENABLE,
"REQUESTID" NUMBER NOT NULL ENABLE,
"FILEID" VARCHAR2(50 BYTE) NOT NULL ENABLE,
"INSERTDATE" TIMESTAMP (6) NOT NULL ENABLE,
"LASTMODIFIEDDATE" TIMESTAMP (6) NOT NULL ENABLE,
"STATUS" VARCHAR2(4000 BYTE),
"RETRIEVABLE" NUMBER(1,0)
)
something like;
impdp directory=DMP dumpfile=DATA.dmp remap_table=CASUSER.CAS_RECONCILIATIONDETAIL:AIC.AIC_CAS_RECONCILIATIONDETAIL tables=CAS_RECONCILIATIONDETAIL
Any help much appreciated.
Thanks and regards,
jd