Neoview Database Administrator's Guide (R2.2)

2. Click the Database tab, then navigate to the schema and click the materialized view name
in the right pane, or open the Materialized Views folder. DB Admin displays the materialized
views in this schema. Click the materialized view name in the lists in either pane. DB Admin
displays the materialized view’s information in the right pane:
Use the arrows on the right to view information under the Attributes, DDL, Space, and
Privileges tabs. Under the DDL tab, the DDL Tool button displays DDL information.
For additional information, see DB Admin online help.
Display DDL information with the DDL Tool by right-clicking the materialized view name
in the tree in the left pane and selecting DDL Tool.... DB Admin displays DDL information
for this materialized view.
Changing Materialized Views
1. Start DB Admin and log on using the user ID that created the table or log on as a user
authorized to change that table.
2. Click the Database tab, then navigate to a materialized view in the left pane.
3. To change the refresh commit value, right-click the materialized view name and then select
Alter and Refresh Commit. You can also click the Alter Refresh Commit button in the right
pane.
4. . DB Admin displays the Alter Materialized View Attributes screen. When you have entered
a row value for Refresh Commit, select Finish.
5. To change the ignore changes on value, right-click the materialized view name and then
select Alter and Ignore Changes On. You can also click the Alter Ignore Changes button
in the right pane. DB Admin displays the Alter Ignore Changes screen. When you have
checked or unchecked the Ignore box, select Finish.
68 Managing Database Objects