Database Export (Unload Database Objects and Data)

Use this wizard to export 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. For example, if you clicked Tools, then Database Export, all panes are available; however, if you right-clicked a table name and selected Export, fewer panes are required.

In several panes, if you select Proceed to summary, clicking Next takes you to the Export Summary page.


See Also:

Cart Versus Database Export Wizard to consider whether you may want to use the Cart instead of the Database Export wizard

Source/Destination page

Contains up to four main areas for specifying the database connection and the DDL, data, and target options. If you specify any options, they override the defaults for Database: Utilities: Export user preferences.

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

Other options on this page: See Database: Utilities: Export for explanations of individual options.

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.

For exporting date fields in date format instead of timestamp format: If you encounter problems exporting dates, check that the following line is in the sqldeveloper.conf file to have dates unloaded in date format: AddVMOption -Doracle.jdbc.mapDateToTimestamp=false

For exporting large tables to Microsoft Excel files:

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

Types to Export page

Specify object types to be exported and options for the export operation.

Object Types: Check the types of objects that you want to export. You can click Toggle All to check and uncheck all individual types. You must select at least one object type.

Specify Objects page

See Specify Objects under Shared Wizard Pages.

Specify Data page

See Data under Shared Wizard Pages.

Export Summary page

See Summary under Shared Wizard Pages.

If a script is created and if Save As was specified as Worksheet, the file is displayed in a SQL Worksheet window, where you can run it as a script and perform other operations.