Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32321: REFRESH FAST of "string"."string" unsupported
after detail table TRUNCATE
- 1 Answers
- 4991 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 |
O2I-00119: Warning reported by subsystem:
ORA-01551: extended rollback segment, pinned blocks released
PLS-00366: subtype of a NOT NULL type must also be NOT NULL
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
UDI-00052: incorrect Data Pump client for operation: string
RMAN-00568: user interrupt received
SQL-02112: SELECT..INTO returns too many rows
ORA-37008: (AWLISTALL06) number writers
ORA-40221: maximum target cardinality exceeded
ORA-02449: unique/primary keys in table referenced by foreign keys
ORA-32592: all columns in log group can not be no log columns
SQL*Loader-00526: OCI return status: success with info
Oracle Errors 
