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
Everything Changes
2 weeks ago
No comments:
Post a Comment