Home > SQL Developer Dialog Boxes ... > Export Objects
This dialog box is displayed when you click the Export icon in the Cart window (described in Using the Cart).
Open Configuration icon: Opens a previously saved XML configuration file, to use its settings as defaults for this use of the dialog box (see Save or Open Cart Tool Configuration).
Save Configuration icon: Saves the current settings in the dialog box to an XML file, which you can later open to use for Cart operations of this type (see Save or Open Cart Tool Configuration).
Export DDL: If this option is checked, the data definition language (DDL) statements for the database objects to be deployed are included in the output file, and the other options in this group affect the content and format of the DDL statements.
For explanations of specific options, see the Export DDL options under Database: Utilities: Export.
Export Data: If this option is checked, the output file or files contain appropriate statements or data for inserting the data for deployed tables and views. If this option is not checked, the data for deployed tables and views is not included; that is, only the DDL statements are included.
Save As: Specifies how or where the 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.
Compressed: If this option is checked, data segments are compressed to reduce disk use.
Encoding: Character set for the statements and data.
File: For exports to one or more files, the .zip file to contain the statements to perform the operation.