CODEWITHSUNDEEP
oracle-databaseshellimpdp
user2854333
user2854333

Reputation: 640

Oracle: Import existing table from dmp into new table

I was able to export the table using below command

exp usr1/user1@tes tables=table1 file=/myfoler/export/parties.dmp log=/myfoler/export/parties.log statistics=none direct=y

But when I am trying to import the dmp file into new table it is failing 

imp usr1/user1@tes file=/myfoler/export/parties.dmp buffer=131072 commit=y log=/myfoler/export/parties_imp.log feedback=1000 ignore=Y tables=export_test

I am getting below error while doing so

IMP-00033: Warning: Table "EXPORT_TEST" not found in export file

Can someone help me understand where I am going wrong? I want to import the dump into new table which is already created.

Upvotes: 3

Views: 1590

Answers (1)

davegreen100
davegreen100

Reputation: 2115

you need to use the REMAP_TABLE option

REMAP_TABLE=[schema.]old_tablename[.partition]:new_tablename

Upvotes: 2

Related Questions