ORA-32315: REFRESH FAST of "string"."string" unsupported
after mixed DML and Direct Load
- 1 Answers
- 1876 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 |
NZE-29095: Index is not correct.
DRG-13010: alt_value is already used by another sub lexer
DRG-10011: invalid object name string
ORA-31116: Tablespace not specified correctly
ORA-27053: blocksize in file header not a multiple of logical block size
RMAN-06193: connected to target database (not started)
NNL-00229: Request-processing delay is now disabled
ORA-02186: tablespace resource privilege may not appear with other privileges
ORA-00285: TIME not given as a string constant
ORA-16529: bad sender id
PCC-00143: Runtime context variable not of correct type
PCC-02319: expression type does not match usage
Oracle Errors 
