The Oracle database plugin uses two operations to synchronize the database structures within a schema. In the source or build environment, the user has the option to either use the recreatedb operation to drop and recreate the database objects based on a supplied SQL/DDL file. The second option is to make the changes in the build database using a tool like SQL Developer or SQL plus. The createbaseline operation is used by the build process in FlexDeploy to store this version of the schema in a DDL repository. During the deployment, the sync operation will then compare this baseline to the existing baseline in that environment. The compare generates the creates, drops, or alters that are necessary to make the target database structures look like the source database structures. Additional operations are available to recompile invalid objects, refresh materialized view, or drop unused columns. These operations can optionally be included in the defined workflow.
| Info |
|---|
|
The baselines are stored in a DDL repository. You must create the DDL Repository schema by downloading and executing the following sql script. |
Supported Versions
- Oracle Database 11.2 (Express, Standard, and Enterprise Edition)
- Oracle Database 12.1 (Standard, and Enterprise Edition)
Key Features
- Easily configured.
- Supports partial deployment of objects.
- Supports a wide range of object types.
- Ability to sync a schema from different starting points.
Plugin Operations
| Child pages (Children Display) |
|---|