ORA-32316: REFRESH FAST of "string"."string" unsupported
after mixed DML
Answer / guest
Cause: One or more of the materialized view logs on the
detail tables referenced by the specified materialized view
omits the sequence number option. Such a log cannot be used
to refresh a materialized view after deletes or updates have
been performed on multiple detail tables.
Action: Use REFRESH COMPLETE. Note: you can use the
DBMS_MVIEW.EXPLAIN_MVIEW() API to determine which
materialized view logs omit the sequence number option.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-30161: A system error occurred during the OCIFile function call
ORA-02245: invalid ROLLBACK SEGMENT name
ORA-10575: Give up restoring recovered datafiles to consistent state: out of memory
ORA-01585: error identifying backup file string
ORA-30550: index depends on a package/function spec/body which is not valid
QSM-01111: no partition key or partition marker found in MV, string
ORA-14012: resulting partition name conflicts with that of an existing partition
ORA-19609: %s is from different backup set: stamp string count string
ORA-01182: cannot create database file string - file is in use or recovery
ORA-16508: channel handle not initialized
ORA-14005: missing RANGE keyword
ORA-26711: remote table does not contain a primary key constraint