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-06777: TLI Driver: error reading parms

1 Answers  


TNS-00141: Failed to get file stream information

1 Answers  


RMAN-08093: specifying current controlfile for proxy backup

1 Answers  


ORA-16117: processing

1 Answers  


ORA-30568: cannot drop log group - nonexistent log group

1 Answers  






ORA-39143: dump file "string" may be an original export dump file

1 Answers  


ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

1 Answers  


ORA-32106: array fetch not allowed without setBuffer on all columns

1 Answers   Oracle,


QSM-01022: a more optimal materialized view than string was used to rewrite

1 Answers  


ORA-00024: logins from more than one process not allowed in single-process mode

1 Answers  


ORA-22863: synonym for datatype string.string not allowed

1 Answers  


ORA-23607: invalid column "string"

1 Answers  


Categories