Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32316: REFRESH FAST of "string"."string" unsupported
after mixed DML
- 1 Answers
- 3124 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 have
been performed on multiple detail tables.
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 |
AUD-00809: ORDSpeechIndex: unable to ALTER REBUILD internal Text index
ORA-32835: database user string does not exist
PLS-01502: Constraint name and constraint status are non-ANSI.
ORA-29830: operator does not exist
IMP-00019: row rejected due to ORACLE error number
ORA-19721: Cannot find datafile with absolute file number string in tablespace string
ORA-39702: database not open for UPGRADE or DOWNGRADE
NNL-00950: Cache lookup requests: number
ORA-01611: thread number string is invalid - must be between 1 and string
ORA-31493: could not prepare session for LogMiner session
TNS-04140: Migration completed successfully.
RMAN-08547: channel string: no autobackups found in the recovery area
Oracle Errors 
