Home > SQL Developer Dialog Boxes ... > Database Export (Unload Dat...
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.
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:
If you encounter problems, try adding the following line to the sqldeveloper.conf file to increase heap size and then restarting SQL Developer: AddVMOption -Xmx1024M
If the number of table rows exceeds 65,536, SQL Developer writes the rows to multiple worksheets within the .xls file.
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.
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.