ORA-32321: REFRESH FAST of "string"."string" unsupported
after detail table TRUNCATE



ORA-32321: REFRESH FAST of "string"."string" unsupported after detail table TRU..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-13608: The task or object name string is invalid.

1 Answers  


QSM-00757: the specified workload string is not referenced by task string

1 Answers  


ORA-00304: requested INSTANCE_NUMBER is busy

1 Answers  


ORA-23494: too many rows for destination "string"

1 Answers  


ORA-34143: (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.

1 Answers  






ORA-09361: Windows 3.1 Two-Task driver unable to lock context area

1 Answers  


ORA-12611: TNS:operation is not portable

1 Answers  


ORA-29664: Unable to generate the helper class for the defined type

1 Answers  


ORA-07619: $IDTOASC failed translating an integrity level

1 Answers  


SQL-02124: NULL value returned by EXEC TOOLS statement

1 Answers  


ORA-16710: The resource guard is out of memory.

1 Answers  


ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 Answers  


Categories