To change an existing MQT into a shadow table, you can modify the properties of
the MQT.
Procedure
To create a shadow table from an existing MQT:
- Make sure that the Properties view is open, then
select the materialized query table in the Data Project
Explorer view. The properties of the object open in the
Properties view.
- On the General page of the Properties view,
specify a table organization, then change the Maintained
by property to
Replication.
Restriction: Shadow tables can be row-organized or
column-organized. However, if you want to specify a primary key
for the table, you must set the Table
organization property to
Column. After you specify the correct
table organization, you can specify the primary key on the Columns
page of the Properties view of the
table.