ORA-32315: REFRESH FAST of "string"."string" unsupported
after mixed DML and Direct Load
- 1 Answers
- 2169 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 |
AMD-00118: output file "string" already exists
ORA-07209: sfofi: file size limit was exceeded.
ORA-15042: ASM disk "string" is missing
TNS-12537: TNS:connection closed
NPL-00307: ASN.1 sequence has already been ended on write
IMG-00805: SIGNATURE data has been corrupted or is invalid
DRG-11870: Response From WAIS Server Too Large -- Extra Lines Ignored
ORA-16229: PDML child string string string for parent string string string cannot be skipped.
PLS-00162: Pragma string expects 4th argument to be a positive integer literal
PROT-00304: Failed to create dump file
NZE-28777: binding creation failure
DRG-11425: gist level string is invalid
Oracle Errors 
