Deploy Objects

This dialog box is displayed when you click the Deploy icon in the SQL Developer Cart window (described in Deploying Objects Using the SQL Developer Cart). You can specify the output file (such as a .zip file) to contain the script files that can be used to deploy the selected objects to the schema of another Oracle Database connection.

The generated script files include a master script that invokes the other scripts. This master script has a name in the format Generated-yyyymmddhhmmss.zip, where yyyymmdd is the master script file creation date and hhmmss is the creation time.

The default values for many options in this dialog box are determined by the Database: Utilities: Export user preferences.

File: Location and name of the output file to contain the generated scripts, plus any before and after scripts that you specified for the deployment. (You can click Browse to find a location.)

Format: Format for the output file (such as ZIP for a .zip file).

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.

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.

Truncate Destination Data: Causes any data in any destination tables or views with the same names to be deleted before the deployed data is inserted. If this option is not selected, the deployed data is appended to any existing data.

Apply: Creates a single file containing the deployment script files, including the master script that invokes the other scripts.