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.
Contents
- 1 Starting the Database Export Wizard
- 2 Database Export Wizard - Panel 1
- 3 Database Export Wizard - Panel 2
- 4 Database Export Wizard - Panel 3
- 5 Database Export Wizard - Panel 4
- 6 Database Export Wizard - Panel 5
- 7 Database Export Wizard - Panel 6
- 8 Database Export Wizard - Panel 7
- 9 Database Export Wizard - Panel 8
Starting the Database Export Wizard
- 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.
- 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.
- Select Utilities > Database Export. The Data Export Wizard opens.
- Use the topics below as a guide to providing information as you walk through the pages of the wizard:
- 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 |
|
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? |
|
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? |
|
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, |
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, |
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.