dropUnusedColumns

Drops columns that have been marked unused.

  

Environment/Instance 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 UserFDORA_USERYes

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 PasswordFDORA_PASSWORDYesThe password for Oracle Database User.
Target JDBC Driver Path.FDORA_DRIVER_PATHYesPath containing JDBC driver for target database connection.

  

Project Properties

Property Name

Property Code

Required

Description

Oracle Database Schema Name(s)FDORA_SCHEMA_NAME

Yes

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 parameter as the schema name.

  

Inputs

Input Name

Input Code

Required

Description





  

Outputs

Output Name

Required

Description

FDORA_OUT_PRE_UNUSED_CNT

No


FDORA_OUT_DROP_UNUSED_COUNTNo

  

Artifacts

This operation doesn’t consume or produce any artifacts.

  

Endpoint Selection

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

  

Endpoint Execution

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

The following macros are not currently supported in the footer:
  • style