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