Database Error Messages

ORA-32443

Cannot create the materialized view REFRESH FAST if the query references an unsupported external table

Cause

An attempt is being made to create the materialized view REFRESH FAST when the query references an unsupported external table.


Action

To enable FAST REFRESH, ensure the materialized view references a supported external table, such as an ORACLE_LOADER type external table created using DBMS_CLOUD.CREATE_EXTERNAL_TABLE() or DBMS_CLOUD.CREATE_EXTERNAL_PART_TABLE() in Oracle Cloud.