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.

The plugin respects table locks, so if a table has locks disabled, the operations will not be able to delete them or modify them. This is a precaution against user error. If you wish to drop or change them, please enable locks first.

DDL Repository

The baselines are stored in a DDL repository. You must create the DDL Repository schema by downloading and executing a script.

These downloads are for version 4.6.0.3.24 and later.

Please note that running this download will require you to drop and recreate your existing fddb schema.

Drop script - drops all tables and sequences from the fddb schema. Some tables may not exist in your schema depending on what version you have. You may safely ignore any errors saying that the table doesn't exist.

4.6 Version FDDB schema ddl (does not include creation of the schema, you may do that per your company standards.

Any builds prior to this will no longer work to deploy. If you are in the middle of a release cycle, you may wish to wait to upgrade to this version of the plugin. The builds will still show up in FlexDeploy but won't work.

Supported Versions

Oracle Database 11.2 (Express, Standard, and Enterprise Edition)
Oracle Database 12.1 (Standard, and Enterprise Edition)

Features delivered by Oracle in 12.1 (like invisible columns) are not currently supported by the plugin.

Key Features

Manage deployments of entire schema(s).
Manage partial deployment of objects in a schema(s).
Supports a wide range of object types.
Source changes from an SCM or "Build Database".
Ability to sync a schema from different starting points.
Manage object renames.
Ability to simulate deployments so that generated DDL can be reviewed ahead of time.
Grants are managed with each object.
Constraints are managed with each Table and View object.

User Permission Requirements

The users specified in FDORA_USER and FDORA_DDL_USER require these permissions:

GRANT EXECUTE on dbms_crypto to <YOUR USER NAME>;
GRANT "SELECT_CATALOG_ROLE" TO <YOUR USER NAME>;
GRANT SELECT ANY DICTIONARY TO <YOUR USER NAME>;
Create Permissions for the schemas to be synced

Supported Oracle Object Types

Sequence
Table
Index
Constraints
View
Synonym
Function
Trigger
Type
Type Body
Package
Package Body
Procedure
Columns
Index
Columns

Grants are also carried forward with the objects

Requirements

The plugin requires that constraints and indexes share the same name.

Supported Versions

Key Features

User Permission Requirements

Supported Oracle Object Types

Requirements

Plugin Operations

Browser not supported