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