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
- 2499 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-02420: missing schema authorization clause
ORA-16794: Database Guard is ON for primary database
NZE-28869: Peer's certificate is expired.
ORA-26064: Invalid SCN specified - Wrap: string Base: string.
ORA-25128: No insert/update/delete on table with constraint (string.string) disabled and validated
PCC-02415: Cannot manipulate Object attributes in an OBJECT GET or SET
ORA-34183: (MXCHGDCL22) Partition number already exists.
NNL-00024: warning: no preferred name servers in SQLNET.ORA
ORA-25130: cannot modify primary key - primary key not defined for table
ORA-28601: invalid [no]MINIMIZE option
ORA-14191: ALLOCATE STORAGE may not be specified for Composite Range partitioned object
TNS-12607: TNS: Connect timeout occurred
Oracle Errors 
