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 "DEPARTMENTS" displayed

• A Schema field with "HR" displayed

• A Tablespace field with "SYSTEM" displayed

• A Last Analyzed Date field with "2/25/09 7:01:01 AM PST" displayed

• A Refresh State field with "UNDEFINED" displayed

• A Compile State field with "VALID" displayed

• An Updatable field with "false" 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 "DEPARTMENT_ID","DEPARTMENT_NAME","MANAGER_ID","LOCATION_ID","TIME" FROM "HR"."DEPARTMENTS"@DB.EXAMPLE.COM c

The Refresh section includes:

• A Refresh Type field with "Complete" displayed

• A Refresh Method field with "Primary Key" displayed

• A Refresh Interval field with "Automatically on 2/26/09 10:38:27 AM PST then refresh every 24 Hours" displayed

• A blank Master Rollback Segment field

• A Local Rollback Segment field with "<Default>" displayed

• A Last Refresh Date field with "2/25/09 4:05:14 PM PST" displayed

• A Refresh Group field with "MVADMIN.MVR" displayed