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

Parameter specifies the maximum size of each dump file. FLASHBACK_SCNThe Oracle Data Pump Export command-line utility FLASHBACK_SCN parameter specifies the system change number (SCN) that Export uses to enable the Flashback Query utility. FLASHBACK_TIMEThe Oracle Data Pump Export command-line utility FLASHBACK_TIME parameter finds the SCN that most closely matches the specified time. FULLThe Export command-line FULL parameter specifies that you want to perform a full database mode export HELPThe Data Pump Export command-line utility HELP parameter displays online help for the Export utility. INCLUDEThe Data Pump Export command-line utility INCLUDE parameter enables you to filter the metadata that is exported by specifying objects and object types for the current export mode. The specified objects and all their dependent objects are exported. Grants on these objects are also exported. JOB_NAMEThe Oracle Data Pump Export command-line utility JOB_NAME parameter identifies the export job in subsequent actions. KEEP_MASTERThe Oracle Data Pump Export command-line utility KEEP_MASTER parameter indicates whether the Data Pump control job table should be deleted or retained at the end of an Oracle Data Pump job that completes successfully. LOGFILEThe Data Pump Export command-line utility LOGFILE parameter specifies the name, and optionally, a directory, for the log file of the export job. LOGTIMEThe Oracle Data Pump Export command-line utility LOGTIME parameter specifies that messages displayed during export operations are timestamped. METRICSThe Oracle Data Pump Export command-line utility METRICS parameter indicates whether you want additional information about the job reported to the Data Pump log file. NETWORK_LINKThe Data Pump Export command-line utility NETWORK_LINK parameter enables an export from a (source) database identified by a valid database link. The data from the source database instance is written to a dump file set on the connected database instance. NOLOGFILEThe Data Pump Export command-line utility NOLOGFILE parameter specifies whether to suppress creation of a log file. PARALLELThe Oracle Data Pump Export command-line utility PARALLEL parameter specifies the maximum number of processes of active execution operating on behalf of the export job. PARALLEL_THRESHOLDThe Oracle Data Pump Export command-line utility PARALLEL_THRESHOLD parameter specifies the size of the divisor that Data Pump uses to calculate potential parallel DML

Excel format. The Rep2excel is developed for Oracle Report; it can convert Oracle report output to Excel format. In other words it can enhance your Oracle Reports Server to generate output with rich formatting from paper layout reports to Excel format. Rep2excel is a win32 console application, It can convert .html file generated by Oracle report server (6i, 9i, 10g)... Category: Internet / Misc. ServersPublisher: Lion Soft Inc., License: Shareware, Price: USD $500.00, File Size: 1.7 MBPlatform: Windows Export Table for Oracle Server helps to save table's data to Excel spreadsheet. Export Table for Oracle Server helps to save table's data to Excel spreadsheet. The program has easy to use wizard interface. All modern versions of Oracle Server and all versions of Microsoft Excel are supported. A few options make export process more flexible and command line support in Professional version of the tool allows user to automate or to schedule export... Category: Business & Finance / Database ManagementPublisher: OmBelt Solutions, License: Demo, Price: USD $49.00, File Size: 429.0 KBPlatform: Windows OraLoader is a Oracle data load/unload tool. Main features: 1. Import data from text,csv,Excel file. 2. Export data to text, csv, excel, html, xml, SQL*Loader control file. 3. Run SQL command, and export result to text, csv, excel, html, xml. OraLoader: Save Your Oracle importing/exporting work. OraLoader is a data conversion tool that helps DBA and database developer import/export Oracle database from/to flat files and Excel files. OraLoader can import/export data easy and fast, saves you a ton of time. By using OraLoader you can move data smoothly, even tables in different databases. Main... Category: Business & Finance / Database ManagementPublisher: Withdata Software, License: Shareware, Price: USD $75.00, File Size: 6.8 MBPlatform: Windows Hxtt Data Export - Excel2Oracle is a program to import MS Excel spreadsheet(95, 97, 98, 2000, 2001, 2002, 2003, 2004) into Oracle(8i, 9, 9i, 10g) database. It can export data in Oracle Procedure, or embed in your application,or accord a config file. Hxtt Data Export - Excel2Oracle is a program to import MS Excel spreadsheet(95, 97, 98, 2000, 2001, 2002, 2003, 2004) into Oracle(8, 8i, 9,