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
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment