Neoview Database Administrator's Guide (R2.3)

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.
76 Managing Database Objects