Data source specific restrictions for materialized query tables

When you create materialized query tables, you need to be aware of restrictions for specific data sources.

This topic describes the restrictions on creating materialized query tables for the following data sources:

Table-structured files

Table-structured file restrictions

If you define a nickname for a table-structured file with the DOCUMENT option, the materialized query table must have a predicate that specifies the file path. If you do not specify a predicate, a refresh of the materialized query table fails.