ORA-32315: REFRESH FAST of "string"."string" unsupported
after mixed DML and Direct Load
- 1 Answers
- 1860 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 |
ORA-14325: only LOCAL indexes may be specified in this clause
PCB-00603: An EXEC TOOLS MESSAGE host variable is not a character type
ORA-16626: failed to enable specified object
PLS-00382: expression is of wrong type
PLS-00630: pipelined functions must have a supported collection return type
ORA-31506: duplicate subscription name string
NZE-29245: the toolkit does not recognize the function being used
DRG-12437: highlight table release failed
TNS-00288: Navigator: Failed to Disable Interchange
ORA-36993: (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
QSM-00504: internal error
RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF
Oracle Errors 
