Refreshes any materialized views that are in a stale or needs compile status.
Target Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database URL |
| Yes | The JDBC URL for the target Oracle database. This should be a complete JDBC URL (e.g. |
Oracle Database 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 |
| Yes | The password for Oracle Database User. |
Target JDBC Driver Path. |
| Yes | Path containing JDBC driver for target database connection. |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database Schema Name(s) |
| 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 |
| No | Method to use to refresh the materialized view.
Defaults to ?. |
Rollback Segment |
| No | Rollback segment to use to refresh the materialized view. Defaults to None. |
Mview Parallelism |
| No | Parallelism to use to refresh the materialized view. Defaults to 0. |
Outputs
Output Name | Required | Description |
|---|---|---|
| No | |
| No |
Artifacts
This operation doesn’t consume or produce any artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the Target.
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.