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, a Georgia Tech graduate Senior Database Engineer/Data Architect based in Atlanta, USA, is an Oracle OCP DBA and Developer, Certified Cloud Architect Professional, and OCI Autonomous Database Specialist. With extensive expertise in database design, configuration, tuning, capacity planning, RAC, DG, scripting, Python, APEX, and PL/SQL, he combines technical mastery with a passion for innovation. Notably, Halim secured 16th place worldwide in PL/SQL Challenge Cup Playoff on the year 2010.
Wednesday, June 29, 2011
How to expdp or impdp some tables from one of the schema out of many schema IN ORACLE DATABASE 10G
Labels:
impdp
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
ASSM states3 weeks ago
-
UKOUG Discover 20241 month ago
-
-
-
-
-
-
-
-
Moving Sideways8 years ago
-
-
Upcoming Events...11 years ago
-
No comments:
Post a Comment