ORA-32321: REFRESH FAST of "string"."string" unsupported
after detail table TRUNCATE
- 1 Answers
- 4579 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A detail table has been truncated and no materialized
view supports fast refersh after a detail table has been
truncated
Action: Use REFRESH COMPLETE. Note: you can determine why
your materialized view does not support fast refresh after
TRUNCATE using the DBMS_MVIEW.EXPLAIN_MVIEW() API.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
DRG-50926: invalid text query string
QSM-02073: non-primary key RepAPI mv is not fast refreshable
PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery
ORA-00305: log string of thread string inconsistent; belongs to another database
PLS-00315: Implementation restriction: unsupported table index type
ORA-04065: not executed, altered or dropped string
DRG-11712: multiple Broader Terms for term string
IMG-02011: 2FF11 - unsupported image format conversion specified
NID-00506: SETNAME Set a new database name only NO
ORA-10642: Found rollback segments in dictionary managed tablespaces
ORA-07507: scgcm: unexpected lock status condition
ORA-02075: another instance changed state of transaction string
Oracle Errors 
