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
- 2505 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-01343: LogMiner encountered corruption in the logstream
ORA-16100: not a valid Logical Standby database
CLSS-02204: voting device not configured. [string] [string]
NNL-00952: Cache lookup failures: number
ORA-07266: sppst: invalid process number passed to sppst.
AMD-00152: Workspace "string" is not currently open.
ORA-06813: TLI Driver: the configured ethernet address is incorrect
ORA-01417: a table may be outer joined to at most one other table
SQL-02122: Invalid OPEN or PREPARE for this database connection
AMD-00118: output file "string" already exists
ORA-25212: invalid PRIORITY specified when using sequence deviation
ORA-24757: duplicate transaction identifier
Oracle Errors 
