Versions Compared

Key

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

Refreshes any materialized views that are in a stale or needs compile status.

  

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

Refresh methodFDORA_MVIEW_METHODNo

Method to use to refresh the materialized view.

F-Fast, P-Fast_PCT, ?-Force, C-Complete

Defaults to ?.

Rollback SegmentFDORA_MVIEW_ROLLBACK_SEGMENTNo

Rollback segment to use to refresh the materialized view.

Defaults to None.

Mview ParallelismFDORA_MVIEW_PARALLELISMNo

Parallelism to use to refresh the materialized view.

Defaults to 0.

  

Outputs

Output Name

Required

Description

FDORA_OUT_REFRESH_COUNT

No


FDORA_OUT_POST_STALE_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.

  

Special Considerations

The default refresh method of ? will tell the Oracle database to determine the best method to refresh the materialized view.