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 Database Export wizard ensures that the proper parameters and privileges are used, provides access to desired database information and resolves version compatibility differences.

The Database Export wizard supports the following export modes:

• Table
• Users
• Full Database
• Point-in-time Recovery

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 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 you want to export 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 following topics to guide you through 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 done, click Execute.

Database Export Wizard - Panel 1

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

The following table describes the options and functionality on the first panel of the Database 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 Database Export wizard lets you select the export mode that determines the database objects you will export. Note that:

• 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 following table 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	Tablespaces.

The following table 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 one of the following options 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 Database Export wizard lets you specify the objects you want to export based on the mode you selected in the second panel of the Database Export wizard.

The following table describes the options and functionality on the third panel of the Database 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 Select All.

The following table describes the options and functionality on the third panel of the Database 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 Select All.

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

Option	Description
Would you like to perform an incremental export?	An incremental operation exports all database objects that 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 Yes.

The following table describes the options and functionality on the third panel of the Database 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 Select All.

Database Export Wizard - Panel 4

The fourth panel of the Database Export wizard lets specify:

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

The following table describes the options and functionality on the fourth panel of the Database 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 changed since the last export operation. Check the box that corresponds to the object(s) you want to export: To export indexes associated with the tables, check Indexes. To export check constraints or referential integrity constraints, check Constraints. To export object privileges, check Grants. To export table data, check Rows.
Rows/Dot	To view the progress meter which displays the status of rows 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 Database Export wizard lets you set the following options:

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

The following table describes the options and functionality on the fifth panel of the Database 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?	Select Yes or No. If you click No, 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 valid only if you are performing a conventional path export. Select Yes or No. If you click No, 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 Database 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 following table describes the options and functionality on the sixth panel of the Database Export wizard:

Option	Description
Would you like table data to be consolidated into one initial extent upon import?	Select Yes or No.
What type of database optimizer statistics should be generated upon import?	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. Select Yes or No. Click Yes to ensure that the data remains intact throughout the export operation.

Database Export Wizard - Panel 7

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

The following table describes the options and functionality on the seventh panel of the Database 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.