Export Wizard

This wizard exports database objects and optionally data. For a selected database connection, you can export some or all objects of one or more types of database objects to output files, a SQL Worksheet, or the clipboard. The output may contain SQL data definition language (DDL) statements to create these objects. It may also contain SQL statements to insert data into these objects and other formatted files.

The number of panes and the options available depend on the potential scope of the export operation.

Source/Destination page

Contains up to four main areas for specifying the database connection and the DDL, data, and target options.

Connection: Select the database connection with the objects to be exported.

Export DDL: If this option is enabled, DDL statements are included in the export operation. Select the options to apply to the DDL that is generated.

Export Data: If this option is enabled, data is included in the operation. Select the options to apply to the data that is unloaded.


Note:

An Export Format Error is displayed if you attempt to export both DDL and Data when Format is loader.

Format: Select the desired output format for the data to be unloaded. Depending on the selected format, other options may appear. For example, for xls (Microsoft Excel file), you can specify worksheet names for the data and the SELECT statement.

For CLOB data, exporting is supported only if the format is loader (SQL*Loader) or pdf (PDF). Some export types export only a subset of the string followed by an ellipsis (...).

To paste unloaded data into a Microsoft Excel file, specify Export Data but not Export DDL, select text for Format, and select Clipboard for Save As; and after completing the unload, paste from the clipboard into Excel.

Save As: Specifies how or where target statements and data are to be saved:

Encoding: Character set to be used for encoding of the output.

Export Summary page

Contains a summary of the actions that will be taken. If you want to change anything, go back and make the changes, then finish the wizard steps.

Export Format Error