Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32315: REFRESH FAST of "string"."string" unsupported
after mixed DML and Direct Load
- 1 Answers
- 2599 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 and
direct path insert.
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 |
QSM-02031: materialized view cannot support any type of query rewrite
KUP-04016: unknown SLF status code number
NNO-00802: Error: OCI_NEED_DATA
ORA-16161: Cannot mix standby and online redo log file members for group string
QSM-01127: query rewritten with multiple MVs
ORA-01479: last character in the buffer is not Null
ORA-06317: IPA: Local maximum number of users exceeded
ORA-25120: MINIMUM EXTENT option already specified
ORA-06262: NETNTT: nfconn() failed
ORA-32146: Cannot perform operation on a null date
QSM-00758: the specified parameter string is not valid for workload string
ORA-12653: Authentication control function failed
Oracle Errors 
