• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 403
  • Last Modified:

datapump syntax for importing a table

Originally table tab_1 was in schema_1. using DataPump, I want to move this table from schema_1 to schema_2.
The script below puts the table back into schema_1
impdp dms/DM_******@ufms020 DIRECTORY=dpump_dir_020 DUMPFILE=MOM_ALL_034.dmp LOGFILE=dmscontent_020_2 TABLES=tab_1

I have created  the table in schema_2

How do I direct datapump to import tab_1 into schema_2
  • 2
1 Solution
KamalAgnihotriAuthor Commented:
I think it can be done. Please update ASAP
To import from a full export file an old schema named fred, into a new schema user named barney...

With impdp:
impdp system/admin directory=dumps dumpfile=export.dmp remap_schema=fred:barney

With imp:
imp system/admin file=export.dmp fromuser=fred touser=barney

Note with impdp you need to create the directory inside Oracle:

create directory dumps as 'C:\dumps';
So for your issue, the important part is:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now