OCI-31905
Synchronous refresh cannot be used for materialized view "string"."string"
string
Cause
The materialized view did not meet the requirements for Synchronous refresh.
Action
The query defining the materialized view must conform to a star or snowflake schema, the fact-table and materialized view must both be partitioned, and the partition-key of the materialized view must be functionally-dependent on the partition-key of the fact-table. Run CAN_SYNCREF_TABLE to obtain more diagnostics and troubleshoot the problem further.
OCI-31905
Synchronous refresh cannot be used for materialized view "string"."string"
string
Cause
The materialized view did not meet the requirements for Synchronous refresh.
Action
The query defining the materialized view must conform to a star or snowflake schema, the fact-table and materialized view must both be partitioned, and the partition-key of the materialized view must be functionally-dependent on the partition-key of the fact-table. Run CAN_SYNCREF_TABLE to obtain more diagnostics and troubleshoot the problem further.
OCI-31905
Synchronous refresh cannot be used for materialized view "string"."string"
string
Cause
The materialized view did not meet the requirements for Synchronous refresh.
Action
The query defining the materialized view must conform to a star or snowflake schema, the fact-table and materialized view must both be partitioned, and the partition-key of the materialized view must be functionally-dependent on the partition-key of the fact-table. Run CAN_SYNCREF_TABLE to obtain more diagnostics and troubleshoot the problem further.