This screenshot shows the View Materialized View page. At the top of the page is an Actions list with a Go button. Next to the list are the Edit and OK buttons. Below the buttons are the following sections: General and Refresh.

The General section includes:

• A Name field with "COUNTRIES_MV2" displayed

• A Schema field with "HR" displayed

• A Tablespace field with "DEMO_MV2" displayed

• A Last Analyzed Date field with "9/21/06 10:05:13 PM PDT" displayed

• A Refresh State field with "UNDEFINED" displayed

• A Compile State field with "Valid" displayed

• An Updatable field with "true" displayed

• A Built From Table field with "false" displayed

• A Number of Indexes field with a "1" link

• A Materialized View Query field with an Explain button and the following text" SELECT "COUNTRIES.COUNTRY_ID" "COUNTRY_ID", "COUNTRIES.COUNTRY_NAME" "COUNTRY_NAME", "COUNTRIES.REGION_ID" "REGION_ID" FROM "HR.COUNTRIES"@II1.NET "COUNTRIES"

The Refresh section includes:

• A Refresh Type field with "Fast" displayed

• A Refresh Method field with "Primary Key" displayed

• A Refresh Interval field with "Automatically on 10/03/06 7:58:24 AM PDT then refresh every 24 hours"

• A blank Master Rollback Segment field