Tuesday, December 8, 2015

IMPDP - import specific table from one schema to another schema

Source schema - UAT_2014_1
Target schema - TEST_SUH
Table to import - USERS

impdp system/password DIRECTORY=SAMPLE_BACKUPS dumpfile=UAT_2014_1_04092014_16.dmp logfile=TEST_SUH_IMPDP.log TABLES=UAT_2014_1.USERS REMAP_SCHEMA=UAT_2014_1:TEST_SUH

To more options
impdp help=y

No comments:

Post a Comment

How to Create TEMPORARY tablespace and drop existing temporary tablespace in oracle 11g/12c

1. Create Temporary Tablespace Temp create temporary tablespace temp2 tempfile '/mnt/mnt04/oradata/temp01.dbf'size 2000M;  2. Move D...