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

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.

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 Name	Input Code	Required	Description
Refresh method	`FDORA_MVIEW_METHOD`	No	Method to use to refresh the materialized view. `F`-Fast, `P`-Fast_PCT, `?`-Force, `C`-Complete Defaults to ?.
Rollback Segment	`FDORA_MVIEW_ROLLBACK_SEGMENT`	No	Rollback segment to use to refresh the materialized view. Defaults to None.
Mview Parallelism	`FDORA_MVIEW_PARALLELISM`	No	Parallelism to use to refresh the materialized view. Defaults to 0.

Input Code

Required

Description

Refresh method

FDORA_MVIEW_METHOD

Method to use to refresh the materialized view.

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

Defaults to ?.

Rollback Segment

FDORA_MVIEW_ROLLBACK_SEGMENT

Rollback segment to use to refresh the materialized view.

Defaults to None.

Mview Parallelism

FDORA_MVIEW_PARALLELISM

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_COUNT`	No

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.

Browser not supported