Use the Materialized (Snapshot) View Editor to view, create or define snapshots.
About Snapshots | A snapshot is a segment that contains the result of a query. The snapshot typically contains local copies of remote objects. From Oracle 8i onwards a materialized view is equivalent to a snapshot but allows queries to be dynamically and transparently rewritten to use the materialized view. |
Icon | Tool Tip | Description | ||||||
---|---|---|---|---|---|---|---|---|
Create new Materialized view |
Open the New Materialized View dialog.
| |||||||
Open object from DB |
Open the Select Materialized View dialog. Select the materialized view from the database. | |||||||
Clone current Materialized view | Create a clone of the selected materialized view. You will be prompted in the New Materialized View dialog to enter new name. | |||||||
Revert to pervious Materialized view | Undo or revert any modifications made to the view. | |||||||
Generate SQL for changes | Generate SQL code for the changes made. | |||||||
Apply changes to DB | Apply changes to the database. |
Tab | Description |
---|---|
Details |
|
Refresh |
|
Storage |
|
Master Info |
Display the owner, table and links for the materialized view (after the materialized view has been saved). |
Icon | Action | Description |
---|---|---|
From the Main Menu View Menu | Visual Object Editors | Materialized View Editor |
Open the Materialized View Editor. | |
From DB Navigator or Find objects Dialog Right click on a Materialized View object and click Open. |
Open the selected Materialized View object in the Materialized View Editor. |
© ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center