Creates a baseline of the given schema name.
A file artifact is created which references a set of DDL in the DDL Repository. This file is then used by the synchronize operation to update the DDL of a target database to the version specified by the build operation's
Revert to Baseline ID value.
Specifying a previous
Revert to Baseline ID value will create an artifact that when deployed will bring the target database DDL to that baseline.
Revert to Baseline ID blank will create an artifact that when deployed will bring the target database DDL to the current DDL of the Source Database.
Revert to Baseline ID supports Full Deployments, not Partial Deployments.
Supported object types are:
- Package Body
- Type Body
- Private Synonym
- Materialized view
- Materialized view log
- Grants on supported objects
Oracle Database URL
The JDBC URL for the target Oracle database.
|Oracle Database User|
|Yes||The username that will be used to connect to the target Oracle Database.|
|Oracle Database Password|
|Yes||The password for Oracle Database User.|
|Target JDBC Driver Path.|
|Yes||Path containing JDBC driver for target database connection.|
|DDL Repo JDBC Driver Path|
|Yes||Path containing JDBC driver for DDL repository database connection.|
|DDL Repository URL|
|Yes||The JDBC URL for the DDL repository.|
|DDL Repository User|
|Yes||The userid used to connect to the DDL repository.|
|DDL Repository Password|
|Yes||The password for the DDL repository userid.|
|Oracle Database Schema Name(s)|
|Comma-separated list of schemas controlled by this project.|
|Oracle Object Types|
The Oracle object types which are being managed in partial deployment projects.
By default all object types are selected.
This could be used in combination with security options so that certain user groups are unable to build and deploy tables or other objects.
|Column Drop Action|
Determines what action to take for "dropping" columns.
Can be set to SET UNUSED or DROP.
Defaults to SET UNUSED.
|Revert to Baseline ID|
Numeric ID of the baseline to revert an environment to.
Leave blank to create a new baseline.
Table rename string. The format is NEW_OWNER.NEW_TABLE_NAME=OLD_OWNER.OLD_TABLE_NAME
NOTE*** Multiple table renames can be listed by comma separating them on the input.
Index rename string. The format is NEW_OWNER.NEW_INDEX_NAME=OLD_OWNER.OLD_INDEX_NAME
NOTE*** Multiple index renames can be listed by comma separating them on the input.
Column rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_COLUMN_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_COLUMN_NAME
NOTE*** Multiple column renames can be listed by comma separating them on the input.
Trigger rename string. The format is NEW_OWNER.NEW_TRIGGER_NAME=OLD_OWNER.OLD_TRIGGER_NAME
NOTE*** Multiple trigger renames can be listed by comma separating them on the input.
Constraint rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_CONSTRAINT_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_CONSTRAINT_NAME
NOTE*** Multiple constraint renames can be listed by comma separating them on the input.
Synonym rename string. The format is NEW_OWNER.NEW_SYNONYM_NAME=OLD_OWNER.OLD_SYNONYM_NAME
NOTE*** Multiple synonym renames can be listed by comma separating them on the input.
Sequence rename string. The format is NEW_OWNER.NEW_SEQUENCE_NAME=OLD_OWNER.OLD_SEQUENCE_NAME
NOTE*** Multiple sequence renames can be listed by comma separating them on the input.
View rename string. The format is NEW_OWNER.NEW_VIEW_NAME=OLD_OWNER.OLD_VIEW_NAME
NOTE*** Multiple view renames can be listed by comma separating them on the input.
Outputs the BaseLine ID which was built.
|No||Count of tables stored in the baseline.|
|No||Count of indexes stored in the baseline.|
|No||Count of constraints stored in the baseline.|
|No||Count of sequences stored in the baseline.|
|No||Count of procedures stored in the baseline.|
|No||Count of views stored in the baseline.|
|No||Count of synonyms stored in the baseline.|
|No||Count of materialized views stored in the baseline.|
|No||Count of materialized view logs stored in the baseline.|
|No||Count of privileges stored in the baseline.|
This operation produces artifacts that will be stored in the artifacts repository. This artifact is an empty file whose name is used to select a revision from the DDL Repository.
This operation will select all available endpoints associated to the environment/instance.
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
For renames, the old_owner must be the same as the new_owner.