ORA-32316: REFRESH FAST of "string"."string" unsupported
after mixed DML



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

Post New Answer

More Oracle Errors Interview Questions

ORA-01166: file number string is larger than string (string)

1 Answers  


LPX-00304: input parameter to function is null

1 Answers  


ORA-01161: database name string in file header does not match given name of string

2 Answers  


DRG-10829: feedback id string is longer than the maximum length of string bytes

1 Answers  


ORA-29913: error in executing string callout

1 Answers  






SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  


ORA-16729: Validating the value of property string hits error string.

1 Answers  


ORA-16727: resource guard cannot close database

1 Answers  


SQL-01075: you are currently logged on

1 Answers  


ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

1 Answers  


ORA-00222: operation would reuse name of a currently mounted controlfile

1 Answers  


TNS-01048: No changes to save for string.

1 Answers  


Categories