What Are Data Pump Export and Import Modes

Q

What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

Data pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes:

Full: Exports and imports a full database. Use the FULL parameter to specify this mode.
Schema: Enables you to export and import all objects that belong to a schema. Use the SCHEMAS parameter to specify this mode. This is the default mode.
Table: Enables you to export and import specific tables and partitions. Use the TABLES parameter to specify this mode.
Tablespace: Enables a privileged user to move a set of tablespaces from one Oracle database to another. Use the TABLESPACES parameter to specify this mode.
Tablespace: Enables a privileged user to move metadata from the tables within a specified set of tablespaces from one Oracle database to another. Use the TRANSPORT_TABLESPACES parameter to specify this mode.

2007-05-01, 7101👍, 0💬

What Is the Data Pump Import Utility
What Is the Data Pump Import Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the... 2007-05-01, 7100👍, 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, 5734👍, 0💬

How To Invoke the Data Pump Export Utility
How To Invoke the Data Pump Export Utility? - Oracle DBA FAQ - Loading and Exporting Data 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. He... 2007-05-01, 5223👍, 0💬

How To Load Data from External Tables to Regular Tables
How To Load Data from External Tables to Regular Tables? - Oracle DBA FAQ - Loading and Exporting Data Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise sho... 2007-05-01, 4815👍, 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, 4803👍, 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, 4749👍, 0💬

How To Invoke the Data Pump Import Utitlity
How To Invoke the Data Pump Import Utitlity? - Oracle DBA FAQ - Loading and Exporting Data The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. H... 2007-05-01, 4747👍, 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, 4717👍, 0💬

What Is the Data Pump Export Utility
What Is the Data Pump Export Utility? - Oracle DBA FAQ - Loading and Exporting Data Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only ... 2007-05-01, 4709👍, 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.