CODEWITHSUNDEEP
databaseoracle-databaseimportdatapump
Godwin
Godwin

Reputation: 13

How to Import some data into a different table name in Oracle database

Please i have a table export that was performed using datapump, and now I want to restore the dump on an archive oracle database, but on a different table name, this table contains lots of partitions, my script is below,

Note: STG_CDR.MSC_CDR_2 is the new table that was created on the new database STG_CDR.MSC_CDR is the old table that was exported into the dump

` directory=IMP_TBS_BK2 dumpfile=TBS_TS_STG_CDR_M_3M201907_01.dmp,TBS_TS_STG_CDR_M_3M201907_02.dmp,TBS_TS_STG_CDR_M_3M201907_03.dmp

logfile=IMP_MSC_CDR_2_201907_1.log

REMAP_SCHEMA=STG_CDR:STG_CDR
REMAP_TABLE=STG_CDR.MSC_CDR:MSC_CDR_2

tables=STG_CDR.MSC_CDR_2:P_20190701,
STG_CDR.MSC_CDR_2:P_20190702,
STG_CDR.MSC_CDR_2:P_20190703,
STG_CDR.MSC_CDR_2:P_20190704,
STG_CDR.MSC_CDR_2:P_20190705,
STG_CDR.MSC_CDR_2:P_20190706

parallel=4 
table_exists_action=append 
job_name=IMP_MSC_CDR_2_201907_1`

But i'm getting error that table does not exit

Upvotes: 0

Views: 331

Answers (0)

Related Questions