Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using expdp/impdp to move data from 1 schema table and append to a table in a different schema

JayDee41Aug 30 2019 — edited Sep 2 2019

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

Comments
Post Details
Added on Aug 30 2019
10 comments
4,392 views