Materialized Tables

A Materialized table in Virtual DataPort is a special type of base view whose data is stored in the database where the data is cached, instead of in an external data source. Unlike the other types of views, its schema and its data are completely managed from Virtual DataPort.

The following sections explain how to create and delete materialized tables and how to insert data into them. You can insert rows into a materialized table but cannot delete or update them.


Before creating any materialized table, enable the cache engine. To do this, follow the steps described in the section Configuring the Cache of the Administration Guide.