Versions Compared

Old Version 39

changes.mady.by.user Karl Henselin

Saved on

compared with

New Version 40

changes.mady.by.user Karl Henselin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

When deploying a baseline that contains rename views, sequences, or synonyms, the value of Environment Instance Target Property FDORA_USER must be the owner of the objects. Running the operation as another user will fail with ORA-04043.

...

Info

When renaming columns and tables in the same build, set the properties like:

FDORA_TABLE_RENAMES - schema.old_table = schema.new_table

FDORA_COLUMN_RENAMES - schema.old_table.old_column = schema.new_table.new_column


As of release 5.5.0.1, you can specify renames without Schema prefixes, provided that you also leave the project property FDORA_SCHEMA_NAME blank. In this case, the schema will be set to the value of FDORA_USER and this value will be used for all renames.


FDORA_TABLE_RENAMES - old_table = new_table

FDORA_COLUMN_RENAMES - old_table.old_column = new_table.new_column

...




Target Properties

Property Name

Property Code

Required

Description

Oracle Database URL

FDORA_URL

Yes

The JDBC URL for the target Oracle database.

This should be a complete JDBC URL (e.g. jdbc:oracle:thin:@localhost:1521:xe)

Oracle Database User

FDORA_USER

Yes

The username that will be used to connect to the target Oracle Database.

NOTE*** If the project property FDORA_SCHEMA_NAME is not set, then this becomes

the schema.

Oracle Database Password

FDORA_PASSWORD

Yes

The password for Oracle Database User.

Target JDBC Driver Path.

FDORA_DRIVER_PATH

Yes

Path containing JDBC driver for target database connection.

DDL Repo JDBC Driver Path

FDORA_DDL_DRIVER_PATH

Yes

Path containing JDBC driver for DDL repository database connection.

DDL Repository URL

FDORA_DDL_URL

Yes

The JDBC URL for the DDL repository.

This should be a complete JDBC URL (e.g. jdbc:oracle:thin:@localhost:1521:xe)

DDL Repository User

FDORA_DDL_USER

Yes

The userid used to connect to the DDL repository.

DDL Repository Password

FDORA_DDL_PASSWORD

Yes

The password for the DDL repository userid.

...

Property Name

Property Code

Required

Description

Oracle Database Schema Name(s)

FDORA_SCHEMA_NAME

No

Comma-separated list of schemas controlled by this project.

Leave this parameter blank if you want to have schema name different across environments.
The plugin will then use the FDORA_USER environment instance Target parameter as the schema name.


If it isn't provided, FDORA_USER will be the schema that is tracked, and may differ through environments.


...

This operation will select all available endpoints associated to the environment/instanceTarget.

Endpoint Execution

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

...