refreshMView
- Karl Henselin
- Jim Hardtke
- Ben Hoffman
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. |
| 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. |
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| Refresh method | FDORA_MVIEW_METHOD | No | Method to use to refresh the materialized view.
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. |
Outputs
Output Name | Required | Description |
|---|---|---|
| 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.
- style