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
- 2431 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-25442: too many column values for table alias: string
ORA-24061: cannot specify non-zero SECONDARY_INSTANCE if PRIMARY_INSTANCE was zero
ORA-19759: block change tracking is not enabled
ORA-02760: Client close of file failed.
TNS-12685: Native service required remotely but disabled locally
PCC-02018: found end-of-file while scanning comment
ORA-30089: missing or invalid <datetime field>
NNL-00801: Queries received, type ANY: number
ORA-14110: partitioning column may not be of type ROWID
ORA-25299: Cannot add buffered subscriber for a non-buffered queue
ORA-26061: Concurrent direct unloads is not allowed.
NNO-00602: warning: forwarder number has invalid address, forwarder ignored
Oracle Errors 
