ORA-32316: REFRESH FAST of "string"."string" unsupported
after mixed DML
- 1 Answers
- 2831 Views
- I also Faced
- E-Mail Answers
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 |
PLS-00371: at most one declaration for 'string' is permitted in the declaration section
ORA-07613: $GETJPIW failed in retrieving the user's process label
ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.
ORA-00279: change string generated at string needed for thread string
ORA-30130: invalid parameter key type received
QSM-02178: MV has a view with UNION ALL that is not fast refreshable
ORA-29834: REF datatype not supported with operators
ORA-02368: file string is not valid for this load operation
ORA-29323: ALTER DATABASE SET COMPATIBILITY command not supported by string
ORA-29819: cannot associate default values with columns
TNS-12663: Services required by client not available on the server
ORA-19206: Invalid value for query or REF CURSOR parameter
Oracle Errors 
