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 "JOBS_MV1" displayed
A Schema field with "HR" displayed
A Tablespace field with "SYSTEM" displayed
A Last Analyzed Date field with "5/9/08 6:35:11 AM 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 "JOBS"."JOB_ID" "JOB_ID","JOBS"."JOB_TITLE" "JOB_TITLE","JOBS"."MIN_SALARY" "MIN_SALARY","JOBS"."MAX_SALARY" "MAX_SALARY" FROM "HR"."JOBS"@II1.EXAMPLE.COM "JOBS"
The Refresh section includes:
A Refresh Type field with "Fast" displayed
A Refresh Method field with "Primary Key" displayed
A Refresh Interval field with "On Demand" displayed
A blank Master Rollback Segment field
A Local Rollback Segment field with "<Default>" displayed
A Last Refresh Date field with "5/8/08 2:28:32 PM PDT" displayed
A blank Refresh Group field