Monday 16 June 2014

IMPORTING OBJECTS OF A TABLE FROM ONE SCHEMA TO OTHER SCHEMA USING DATA PUMP

Here Below i have explained to import the object of specific table from one schema to other schema

impdp userid=\"/ as sysdba\" tables=T1 directory=DP dumpfile=table1.dmp logfile=tableimp1.log TABLE_EXISTS_ACTION=SKIP REMAP_SCHEMA=source schema:target schema

Above command will only include objects related to that table.



No comments:

Post a Comment