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-30939: Order violation: Element 'string' may not follow element 'string'

1 Answers  


PLS-00727: MODIFY LIMIT is supported only on schema-level varray types

1 Answers  


ORA-00103: invalid network protocol; reserved for use by dispatchers

1 Answers  


NNO-00114: line string: other data exists, alias data ignored

1 Answers  


ORA-28172: distinguished name not provided by proxy

1 Answers  


ORA-16711: the resource guard index is out of bounds

1 Answers  


ORA-01078: failure in processing system parameters

1 Answers  


CLSR-00512: Invalid CAA trigger event type [string]

1 Answers  


TNS-00219: Pump Strategy : string

1 Answers  


ORA-31069: Cannot apply typed changes to non-schema-based XMLType nodes

1 Answers  


LSX-00280: duplicate ID "~S"

1 Answers  


ORA-31030: Unable to retrieve XML document

1 Answers  


Categories