About Installation Script Files

To deploy an application, you run one or more installation script files. If these files do not exist, you can create them, with SQL Developer or any text editor.

An installation script file is an executable file (.sql file) that contains an installation script. An installation script is composed ot DDL statements, INSERT statements, or both. When you run your installation script files, the DDL statements create the schema objects of your application in the deployment environment, and the INSERT statements insert the data from the tables in your development environment (the source tables) into the corresponding tables in the deployment environment (the new tables).

This section contains:

• About DDL Statements and Schema Object Dependencies

• About INSERT Statements and Constraints