Database Export (ORCL)

Go Up to Data, Schema, and Miscellaneous Utilities

DBArtisan provides comprehensive graphical support for the Oracle Export Utilities. DBArtisan offers a simple wizard that guides you through the process of extracting object definitions and table data from an Oracle database and creating binary export file. DBArtisan's Export Wizard ensures that the proper parameters and privileges are used, provides access to desired database information and resolves version compatibility differences.

The Export Wizard supports all four export modes:

• Table
• Users
• Full Database
• Point-in-time Recovery (available in Oracle8)

The benefits of using the Oracle Export Utilities range from moving data between different versions of Oracle quickly and efficiently, saving space on the database, to selectively backing up an entire or portion of a database using cumulative or incremental export functions.

Note: If you do not have the EXP_FULL_DATABASE role assigned to you, you may not be able to access all the functionality of the export wizard.

Starting the Database Export Wizard

1. Ensure that the path and name for the Oracle Export utility is specified in the Oracle Utilities tab of the Options Editor. For details, see Oracle Utilities Options.
2. Connect to the datasource where the database to be exported is located and ensure that it is the selected datasource. For details, see Connected/Selected Datasource options.
3. Select Utilities > Database Export. The Data Export Wizard opens.
4. Use the topics below as a guide to providing information as you walk through the pages of the wizard:
   • Database Export Wizard - Panel 1
   • Database Export Wizard - Panel 2
   • Database Export Wizard - Panel 3
   • Database Export Wizard - Panel 4
   • Database Export Wizard - Panel 5
   • Database Export Wizard - Panel 6
   • Database Export Wizard - Panel 7
   • Database Export Wizard - Panel 8
5. When ready, click Execute.

Database Export Wizard - Panel 1

The first panel of the Export Wizard lets you specify the source datasource, name an existing parameter file or use the existing Oracle default parameter file.

The table below describes the options and functionality on the first panel of the Data Export Wizard:

Option	Description
Which database has the data you wish to export?	Click the list, and then click the database.
Edit an existing parameter file	Type the location and name of the parameter file or click the browse button to find the file.
Default values	To use the Oracle default values for the parameter file, leave this box blank.

Database Export Wizard - Panel 2

The second panel of the Export Wizard lets you select the export mode that determines the database objects you will export.

• The full database mode makes available incremental, cumulative or complete export operations.
• The point-in-time export operation can export one or more tablespaces, which you can use in an import operation to recover a tablespace at a prior point in time without affecting the rest of the database.

The table below describes the objects, related objects and structures that are exported for each mode:

Mode	Object Types and Structures
Table	Table definitions, object types defined on the table, table data by partition, nested table data, indexes defined on the table, table constraints, table permissions, column and table comments, table analysis information, triggers that refer to the table, and auditing information.
User	Libraries, object types, database links, sequence numbers, cluster definitions, table definitions, object types defined on the table, table data by partition, nested table data, indexes defined on the table, table constraints, table permissions, table analysis information, column and table comments, private synonyms, stored procedures, functions, packages, auditing information, views, cluster analysis information, referential constraints, triggers, snapshots, and snapshot logs.
Full Database	Tablespace definitions, tablespace quotas, profiles, user definitions, roles, role privileges, system privileges, resource costs, rollback segment definitions, database links, sequence numbers, directories, libraries, object types, cluster definitions, password information, default and system auditing, object type tables, table definitions, table data by partition, nested table data, table indexes, table constraints, table privileges, table analysis information, column and table comments, auditing information, synonyms, views, stored procedures, functions, packages, triggers, cluster analysis information, snapshots, snapshot logs, refresh groups and children.
Point-In-Time (available in Oracle8)	Tablespaces.

The table below describes the options and functionality on the second panel of the Data Export Wizard:

Option	Description
Which mode would you like to use for this export?	Click the option button that corresponds to the export mode you want to implement: Table, User, Full Database, or Point-in-Time Recovery.

Database Export Wizard - Panel 3

The third panel of the Export Wizard lets you specify the objects you want to export based on the mode you selected in the second panel of the Export Wizard.

The table below describes the options and functionality on the third panel of the Data Export Wizard for Table mode:

Option	Description
Select the tables and/or partitions you would like to export	To display list of available tables, click the Owner list, and then click the owner.
Tables	In the box, select the check boxes that correspond to the tables you want to export. If a table has partitions, select the check boxes that correspond the partitions you want to export. To select all tables, click the Select All button.

The table below describes the options and functionality on the third panel of the Data Export Wizard for User mode:

Option	Description
Select the users whose objects you would like to export	To display list of available users, select the check boxes that correspond to the objects you want to export. To select all objects, click the Select All button.

The table below describes the options and functionality on the third panel of the Data Export Wizard for Full Database mode:

Option	Description
Would you like to perform an incremental export	An incremental operation exports all database objects that have changed since the last incremental, cumulative, or complete export operation. NOTE: To perform an incremental export operation, you must have the EXP_FULL_DATABASE role. A cumulative operation exports all database objects that have changed since the last cumulative or complete export. A complete operation exports all objects.
Do you want to records this export in the system tables that track exports?	To record the export operation in the SYS.INEXP, SYS.INCFIL, and SYS.INVID system tables, click the Yes button.

The table below describes the options and functionality on the third panel of the Data Export Wizard for Point-in-Time Recovery mode:

Option	Description
Select the tablespaces to be recovered	To display list of available tablespaces, select the check boxes that correspond to the tablespaces you want to recover. To recover all tablespaces, click the Select All button.

Database Export Wizard - Panel 4

The fourth panel of the Export Wizard lets specify:

• The objects you want to export.
• To view the progress meter.

The table below describes the options and functionality on the fourth panel of the Data Export Wizard:

Option	Description
Check the objects you would like to export	Note: This option is not available if you are performing a full database incremental export operation. The Oracle Export Utility automatically determines if a row has been changed since the last export operation. Select the check box that corresponds to the object(s) you want to export: To export indexes associated with the tables, select the Indexes check box. To export check constraints or referential integrity constraints, select the Constraints check box. To export object privileges, select the Grants check box. To export table data, select the Rows check box.
Rows/Dot	To view the progress meter which displays the status of rows being exported, in the box, type the value of the number of rows per dot you want displayed in the meter.

Database Export Wizard - Panel 5

The fifth panel of the Export Wizard lets you set the following options:

• The Export Path
• The Length of the File Record
• The Buffer Size

The table below describes the options and functionality on the fifth panel of the Data Export Wizard:

Option	Description
Would you like to perform a direct path export?	A direct path export extracts data much faster as it bypasses the SQL Command processing layer and saves data copies whenever possible.
Would you like to accept your platform's value for BUFSIZ as the length of the file record?	Lets you select the Yes or No option button. If you clicked the No option button, in the Specify length box, type the KB value of the length. The highest value you can specify is 64 KB.
Would you like to accept your platform's default value for the buffer size used to fetch rows?	Note: This option is only valid if you are performing a conventional path export. Lets you select the Yes or No option button. If you clicked the No option button, in the Specify size box, type the KB value of the length; the highest value you can specify is 64 KB.

Database Export Wizard - Panel 6

The sixth panel of the Export Wizard lets you specify:

• Handling storage of table data.
• Type of optimizer statistics to generate when the file is imported.
• Make the data remain unchanged during the export operation.

The table below describes the options and functionality on the sixth panel of the Data Export Wizard:

Option	Description
Would you like table data to be consolidated into one initial extent upon import?	Lets you select the No or Yes option button.
What type of database optimizer statistics should be generated upon import?	Lets you click the appropriate option button: Estimate, Compute, or None.
Would you like to ensure that the data seen by this export operation does not change during execution?	Note: This option is not available for an incremental export operation. Lets you select the No or Yes option button. Click Yes to ensure that the data remains intact throughout the export operation.

Database Export Wizard - Panel 7

The seventh panel of the Export Wizard lets you specify names and locations for the export, parameter and logfiles.

The table below describes the options and functionality on the seventh panel of the Data Export Wizard:

Option	Description
Supply the export file name	Lets you type the full location and name of the export file. Export file names use the.dmp file extension. (for example, C:\Temp\EXPBerlin.dmp). If you expect to perform the same export operation again, type the location and name of the parameter file in the corresponding box. Parameter files are stored as.txt files. (for example, C:\Temp\EXPPARBerlin.txt).
Logfile	To capture informational and error messages, click the option button and type the location and name of the logfile in the corresponding box. Export logfile names use the.logfile extension. (for example, C:\Temp\EXPLOGBerlin.log).
None	If you do not want to capture informational and error messages, click the option button.

Database Export Wizard - Panel 8

Review the data export operation description to verify its accuracy.