Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-31935

REFRESH FAST of "string"."string" unsupported with SKIP_EXT_DATA = FALSE

Cause

The REFRESH command specified the value of the parameter SKIP_EXT_DATA as FALSE. This materialized view does not support fast refresh when SKIP_EXT_DATA = FALSE is specified.


Action

Use REFRESH COMPLETE with SKIP_EXT_DATA = FALSE to refresh with data from external partitions. If you do not want to use data from external partitions, you can use fast refresh with SKIP_EXT_DATA = TRUE.