Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Invoke the Data Pump Export Utility

By: FYIcenter.com

(Continued from previous topic...)

How To Invoke the Data Pump Export Utility?

The Data Pump Export utility is distributed as executable file called "expdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "expdp" command. Here is tutorial exercise on how to invoke the export utility:

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

>expdp help=y
Export: Release 10.2.0.1.0 - 

The Data Pump export utility provides a mechanism for
transferring data objects between Oracle databases. The 
utility is invoked with the following command:

   Example: expdp scott/tiger DIRECTORY=dmpdir
     DUMPFILE=scott.dmp

You can control how Export runs by entering the 'expdp'
command followed by various parameters:

   Format:  expdp KEYWORD=value or
     KEYWORD=(value1,value2,...,valueN)

   Example: expdp scott/tiger DUMPFILE=scott.dmp
     DIRECTORY=dmpdir 
               SCHEMAS=scott or TABLES=(T1:P1,T1:P2)

USERID must be the first parameter on the command line.

Keyword       Description (Default)
------------------------------------------------------------
ATTACH        Attach to existing job, e.g. ATTACH [=job name
COMPRESSION   Reduce size of dumpfile contents where valid
              keyword values are: (METADATA_ONLY) and NONE.
DIRECTORY     Directory object to be used for dumpfiles 
DUMPFILE      List of destination dump files (expdat.dmp).
FLASHBACK_SCN SCN used to set session snapshot back to.
FULL          Export entire database (N).
HELP          Display Help messages (N).
......

(Continued on next topic...)

  1. What Is the Simplest Tool to Run Commands on Oracle Servers?
  2. What Is the Quickest Way to Export a Table to a Flat File?
  3. How To Export Data with a Field Delimiter?
  4. What Is SQL*Loader?
  5. What Is a SQL*Loader Control File?
  6. How To Load Data with SQL*Loader?
  7. What Is an External Table?
  8. How To Load Data through External Tables?
  9. What Are the Restrictions on External Table Columns?
  10. What Is a Directory Object?
  11. How To Define an External Table in a Text File?
  12. How To Run Queries on External Tables?
  13. How To Load Data from External Tables to Regular Tables?
  14. What Is the Data Pump Export Utility?
  15. What Is the Data Pump Import Utility?
  16. How To Invoke the Data Pump Export Utility?
  17. How To Invoke the Data Pump Import Utility?
  18. What Are Data Pump Export and Import Modes?
  19. How To Estimate Disk Space Needed for an Export Job?
  20. How To Do a Full Database Export?
  21. Where Is the Export Dump File Located?
  22. How To Export Your Own Schema?
  23. How To Export Several Tables Together?
  24. What Happens If the Imported Table Already Exists?
  25. How To Import One Table Back from a Dump File?
  26. What Are the Original Export and Import Utilities?
  27. How To Invoke Original Export/Import Utilities?

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...