Wednesday, June 29, 2011

How to expdp or impdp some tables from one of the schema out of many schema IN ORACLE DATABASE 10G

How to expdp or impdp some tables from one of the schema out of many schema IN ORACLE DATABASE 10G
==================================================================================================

expdp stlbas/stlbas@stlbas_105 tables=stlbas.stfacmas,stlbas.stfalimt,stlbas.stprodct,stlbas.stfetran directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log

impdp stlbas/stlbas@stlbas_105 tables=stlbas.stfacmas,stlbas.stfalimt,stlbas.stprodct,stlbas.stfetran directory=dir_stlbas table_exists_action=replace dumpfile=stelar.dmp logfile=stelar_tables.log

or

expdp scott/tiger@stlbas_105 schemas=Stlbas include=TABLE:"IN ('STFACMAS', 'STFALIMT',STPRODCT,STFETRAN)" directory=dir_stlbas dumpfile=stelar.dmp logfile=stelar_tables.log

IMPdp scott/tiger@stlbas_105 schemas=Stlbas include=TABLE:"IN ('STFACMAS', 'STFALIMT',STPRODCT,STFETRAN)" directory=dir_stlbas table_exists_action=replace dumpfile=stelar.dmp logfile=stelar_tables.log


see more here http://www.oracle-base.com/articles/10g/OracleDataPump10g.php

No comments: