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-01166: file number string is larger than string (string)
LPX-00304: input parameter to function is null
ORA-01161: database name string in file header does not match given name of string
DRG-10829: feedback id string is longer than the maximum length of string bytes
ORA-29913: error in executing string callout
SQL*Loader-00272: Table level OPTIONS statement ignored.
ORA-16729: Validating the value of property string hits error string.
ORA-16727: resource guard cannot close database
SQL-01075: you are currently logged on
ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index
ORA-00222: operation would reuse name of a currently mounted controlfile
TNS-01048: No changes to save for string.