Oracle Export

Set. COMPRESSION_ALGORITHMThe Oracle Data Pump Export command-line utility COMPRESSION_ALGORITHM parameter specifies the compression algorithm that you want to use when compressing dump file data. CONTENTThe Oracle Data Pump Export command-line utility CONTENT parameter enables you to filter what Export unloads: data only, metadata only, or both. DATA_OPTIONSThe Oracle Data Pump Export command-line utility DATA_OPTIONS parameter designates how you want certain types of data handled during export operations. DIRECTORYThe Oracle Data Pump Export command-line utility DIRECTORY parameter specifies the default location to which Export can write the dump file set and the log file. DUMPFILEThe Oracle Data Pump Export command-line utility DUMPFILE parameter specifies the names, and optionally, the directory objects of dump files for an export job. ENABLE_SECURE_ROLESThe Oracle Data Pump Export command-line utility ENABLE_SECURE_ROLES parameter prevents inadvertent use of protected roles during exports. ENCRYPTIONThe Oracle Data Pump Export command-line utility ENCRYPTION parameter specifies whether to encrypt data before writing it to the dump file set. ENCRYPTION_ALGORITHMThe Oracle Data Pump Export command-line utility ENCRYPTION_ALGORITHM parameter specifies which cryptographic algorithm should be used to perform the encryption. ENCRYPTION_MODEThe Oracle Data Pump Export command-line utility ENCRYPTION_MODE parameter specifies the type of security to use when encryption and decryption are performed. ENCRYPTION_PASSWORDThe Oracle Data Pump Export command-line utility ENCRYPTION_PASSWORD parameter specifies a password for encrypting encrypted column data, metadata, or table data in the export dump file. This parameter prevents unauthorized access to an encrypted dump file set. ENCRYPTION_PWD_PROMPTThe Oracle Data Pump Export command-line utility ENCRYPTION_PWD_PROMPT specifies whether Oracle Data Pump prompts you for the encryption password. ESTIMATEThe Oracle Data Pump Export command-line utility ESTIMATE parameter specifies the method that Export uses to estimate how much disk space each table in the export job will consume (in bytes). ESTIMATE_ONLYThe Oracle Data Pump Export command-line utility ESTIMATE_ONLY parameter instructs Export to estimate the space that a job consumes, without actually performing the export operation. EXCLUDEThe Data Pump Export command-line utility EXCLUDE parameter enables you to filter the metadata that is exported by specifying objects and object types that you want to exclude from the export operation. FILESIZEThe Oracle Data Pump Export command-line utility FILESIZE

Based on table size PARFILEThe Oracle Data Pump Export command-line utility PARFILE parameter specifies the name of an export parameter file. QUERYThe Oracle Data Pump Export command-line utility QUERY parameter enables you to specify a query clause that is used to filter the data that gets exported. REMAP_DATAThe Oracle Data Pump Export command-line utility REMAP_DATA parameter enables you to specify a remap function that takes as a source the original value of the designated column and returns a remapped value that replaces the original value in the dump file. REUSE_DUMPFILESThe Oracle Data Pump Export command-line utility REUSE_DUMPFILES parameter specifies whether to overwrite a preexisting dump file. SAMPLEThe Oracle Data Pump Export command-line utility SAMPLE parameter specifies a percentage of the data rows that you want to be sampled and unloaded from the source database. SCHEMASThe Oracle Data Pump Export command-line utility SCHEMAS parameter specifies that you want to perform a schema-mode export. SERVICE_NAMEThe Oracle Data Pump Export command-line utility SERVICE_NAME parameter specifies a service name that you want to use in conjunction with the CLUSTER parameter. SOURCE_EDITIONThe Oracle Data Pump Export command-line utility SOURCE_EDITION parameter specifies the database edition from which objects are exported. STATUSThe Oracle Data Pump Export command-line utility STATUS parameter specifies the frequency at which the job status display is updated. TABLESThe Oracle Data Pump Export command-line utility TABLES parameter specifies that you want to perform a table-mode export. TABLESPACESThe Oracle Data Pump Export command-line utility TABLESPACES parameter specifies a list of tablespace names that you want to be exported in tablespace mode. TRANSPORT_FULL_CHECKThe Oracle Data Pump Export command-line utility TRANSPORT_FULL_CHECK parameter specifies whether to check for dependencies between objects TRANSPORT_TABLESPACESThe Oracle Data Pump Export command-line utility TRANSPORT_TABLESPACES parameter specifies that you want to perform an export in transportable-tablespace mode. TRANSPORTABLEThe Oracle Data Pump Export command-line utility TRANSPORTABLE parameter specifies whether the transportable option should be used during a table mode or full mode export. TTS_CLOSURE_CHECKThe Oracle Data Pump Export command-line mode TTS_CLOSURE_CHECK parameter is used to indicate the degree of closure checking to be performed as part of a Data Pump transportable tablespace operation. VERSIONThe Data

The Export parameters that you specify. You can specify these parameters either on the command line, or in a parameter file. Caution: Do not start Export as SYSDBA, except at the request of Oracle technical support. SYSDBA is used internally and has specialized functions; its behavior is not the same as for general users. Oracle Data Pump Export InterfacesYou can interact with Oracle Data Pump Export by using a command line, a parameter file, or an interactive-command mode. Oracle Data Pump Export ModesExport provides different modes for unloading different portions of Oracle Database data. Network Considerations for Oracle Data Pump ExportLearn how Oracle Data Pump Export utility expdp identifies instances with connect identifiers in the connection string using Oracle*Net or a net service name, and how they are different from export operations using the NETWORK_LINK parameter. 2.2.1 Oracle Data Pump Export Interfaces You can interact with Oracle Data Pump Export by using a command line, a parameter file, or an interactive-command mode. Choose among the three options: Command-Line Interface: Enables you to specify most of the Export parameters directly on the command line. Parameter File Interface: Enables you to specify command-line parameters in a parameter file. The only exception is the PARFILE parameter, because parameter files cannot be nested. If you are using parameters whose values require quotation marks, then Oracle recommends that you use parameter files. Interactive-Command Interface: Stops logging to the terminal and displays the Export prompt, from which you can enter various commands, some of which are specific to interactive-command mode. This mode is enabled by pressing Ctrl+C during an export operation started with the command-line interface, or the parameter file interface. Interactive-command mode is also enabled when you attach to an executing or stopped job. 2.2.2 Oracle Data Pump Export Modes Export provides different modes for unloading different portions of Oracle Database data. Specify export modes on the command line, using the appropriate parameter. Note: You cannot export several Oracle-managed system schemas for Oracle Database, because they are not user schemas; they contain Oracle-managed data and metadata. Examples of system schemas that are not exported include

The Oracle Data Pump Export utility is used to unload data and metadata into a set of operating system files, which are called a dump file set.2.1 What Is Oracle Data Pump Export? Oracle Data Pump Export is a utility for unloading data and metadata into a set of operating system files that are called a dump file set. You can import a dump file set only by using the Oracle Data Pump Import utility. You can import the dump file set on the same system, or import it to another system, and load the dump file set there. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information. The files are written in a proprietary, binary format. During an import operation, the Oracle Data Pump Import utility uses these files to locate each database object in the dump file set. Because the dump files are written by the server, rather than by the client, you must create directory objects that define the server locations to which files are written. Oracle Data Pump Export enables you to specify that you want a job to move a subset of the data and metadata, as determined by the export mode. This subset selection is done by using data filters and metadata filters, which are specified through Oracle Data Pump Export parameters. Note: Several system schemas cannot be exported, because they are not user schemas; they contain Oracle-managed data and metadata. Examples of schemas that are not exported include SYS, ORDSYS, and MDSYS. Secondary objects are also not exported, because the CREATE INDEX run at import time will recreate them. Related Topics Understanding Dump_ Log_ and SQL File Default Locations Filtering During Export Operations Export Utility (exp or expdp) does not Export DR${name}$% or DR#{name}$% Secondary Tables of Text Indexes (Doc ID 139388.1) Examples of Using Oracle Data Pump Export 2.2 Starting Oracle Data Pump Export Start the Oracle Data Pump Export utility by using the expdp command. The characteristics of the Oracle Data Pump export operation are determined by