ORA-32315: REFRESH FAST of "string"."string" unsupported
after mixed DML and Direct Load
- 1 Answers
- 1886 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 |
EXP-00034: error on rowid: file# number block# number slot# number
ORA-29384: number of children for plan string exceeds string
ORA-06518: PL/SQL: Probe version string incompatible with version string
ORA-19800: Unable to initialize Oracle Managed Destination
ORA-31089: schema "string" does not target namespace "string"
ORA-29843: indextype should support atleast one operator
SQL*Loader-00122: Invalid skip_index_maintenance option
PCC-02133: CMD-LINE: Error in string processing function
ORA-01488: invalid nibble or byte in the input data
ORA-09875: TASDEF_WRITE: write error when writing ?/dbs/tasdef@.dbf file.
ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated
NCR-03016: NCRO: Message has bad address
Oracle Errors 
