Home > Data Modeler Dialog Boxes > 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.
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:
Single File: A single file contains both DDL and data. When you are unloading DDL, only Insert format can be specified for data.
Separate Files: Each object is saved to a separate file in the specified directory.
Type Files: Objects of the same type are saved to a single file in the specified directory.
Separate Directories: A directory for each object type being exported is created. Files are created in the appropriate directory.
Worksheet: Statements are sent to a SQL Worksheet window.
Clipboard: Statements are copied to the clipboard.
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