How To Export Several Tables Together

Q

How To Export Several Tables Together? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise:

>cd \oraclexe\app\oracle\product\10.2.0\server\BIN

>expdp hr/fyicenter TABLES=employees,departments 
  DIRECTORY=hr_dump DUMPFILE=tables.dmp LOGFILE=tables.log

Starting "HR"."SYS_EXPORT_TABLE_01":  hr/******** 
  TABLES=employees,departments DIRECTORY=hr_dump
  DUMPFILE=tables.dmp 
  LOGFILE=tables.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CON...
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTI...
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF...
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TAB...
. . exported "HR"."DEPARTMENTS"       6.632 KB      27 rows
. . exported "HR"."EMPLOYEES"         15.76 KB     107 rows
Master table "HR"."SYS_EXPORT_TABLE_01" loaded/unloaded
***********************************************************
Dump file set for HR.SYS_EXPORT_TABLE_01 is:
  C:\ORACLEXE\HR_DUMP\TABLES.DMP
Job "HR"."SYS_EXPORT_TABLE_01" successfully completed

2007-05-01, 5213👍, 0💬

How To Estimate Disk Space Needed for an Export Job
How To Estimate Disk Space Needed for an Export Job? - Oracle DBA FAQ - Loading and Exporting Data If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you ... 2007-05-01, 6446👍, 0💬

What Are the Original Export and Import Utilities
What Are the Original Export and Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with differen... 2007-05-02, 5963👍, 0💬

How To Import One Table Back from a Dump File
How To Import One Table Back from a Dump File? - Oracle DBA FAQ - Loading and Exporting Data If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import th... 2007-05-02, 5659👍, 0💬

Where Is the Export Dump File Located
Where Is the Export Dump File Located? - Oracle DBA FAQ - Loading and Exporting Data If you are not specifying the dump directory and file name, the dump file will be stored in the default dump directory with the default file name. The tutorial exercise below tells you find what is your default dump... 2007-05-01, 5632👍, 0💬

How To Export Your Own Schema
How To Export Your Own Schema? - Oracle DBA FAQ - Loading and Exporting Data If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system... 2007-05-01, 5519👍, 0💬

How To Do a Full Database Export
How To Do a Full Database Export? - Oracle DBA FAQ - Loading and Exporting Data If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: >expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXP... 2007-05-01, 5449👍, 0💬

How To Invoke the Original Export Import Utilities
How To Invoke the Original Export Import Utilities? - Oracle DBA FAQ - Loading and Exporting Data If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you ho... 2007-05-02, 5253👍, 0💬

How To Export Several Tables Together
How To Export Several Tables Together? - Oracle DBA FAQ - Loading and Exporting Data If you don't want to export the entire schema and only want to export several tables only, you can use the "expdp" command with the "TABLES" parameter as shown in the following tutorial exercise: >cd \oraclexe\app\o... 2007-05-01, 5214👍, 0💬

What Happens If the Imported Table Already Exists
What Happens If the Imported Table Already Exists? - Oracle DBA FAQ - Loading and Exporting Data If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\ap... 2007-05-02, 5139👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.