Choose Create from the Schema Manager Object menu.
2.
Select Snapshot from the list in the Create Object dialog box. The Create
Snapshot property sheet appears.
3.
Enter the requisite information.
4.
Click Create.
The property sheet consists of four pages:
■
General
■
Cluster
■
Storage (Advanced Mode only, see Schema Object Property Sheet: Storage Page on
page 11-5)
■
Options (Advanced Mode only, see Schema Object Property Sheet: Options Page
on page 11-7)
Snapshot Property Sheet: General Page
The General page contains the following:
Name
Name of the snapshot being defined. During the Create operation, you can specify
a valid Oracle identifier as the name of the sequence.
Schema
Name of the schema containing the snapshot. The drop-down list contains all
available schemas within the connected database.
Tablespace
Name of the tablespace to which the snapshot belongs.
Refresh Type
Type of refresh for automatic refreshes: Complete, Fast, or Force.
Complete: Specifies a refresh that executes the subquery.
Fast: Specifies a refresh using only the updated data stored in the snapshot log
associated with the master table.
11-36Oracle Enterprise Manager Administrator’s Guide
Snapshots Folder
Force: Specifies a fast refresh if one is possible or a complete refresh if fast refresh is not possible.
Start Date: Date snapshot refresh is to begin.
Next Date: Expression that calculates the interval at which the snapshot is updated.
Updatable
When selected, indicates that the snapshot is updatable. When used in conjunction
with the Replication Option, updates are propagated to the master.
Snapshot Subquery
Snapshot query executed by Oracle when you create the snapshot. Results of the
query are placed in the snapshot. (Create only)
Snapshot Property Sheet: Cluster Page
The Cluster page allows you to define the cluster to which a snapshot belongs. This
property sheet contains the following:
Cluster
Cluster to which the snapshot belongs. The drop-down list displays all clusters
contained within the selected schema.
Column Name: Name of the column to be used as part of the snapshot. Click Add to
add the column name to the Snapshot Columns list.
Snapshot Columns: Scrolling list of all columns added to the snapshot. Use the Up/
Down arrows to reorder the list of columns (column order must match the order in
the cluster).
Remove: Deletes the selected snapshot column from the list.
Create Like Snapshot
To create a snapshot with parameters that are identical to an existing snapshot:
1.
Select an existing snapshot from the navigator.
2.
Choose Create Like from the Object menu. The Create Snapshot property sheet
appears.
3.
Enter a name and modify the property sheet parameters (if necessary).
4.
Click Create.
Managing Schema Objects
11-37
Synonyms Folder
Editing a Snapshot
To edit an existing snapshot:
1.
Select a snapshot in the navigator. A property sheet with the snapshot’s current
parameters displays.
This property sheet is similar to the Create Snapshot property sheet except that the
Subquery entry field is replaced by the following information:
Trigger
Associated AFTERROW trigger on the master table.
Log
Associated snapshot log.
Master Info
Owner: Name of the schema to which the snapshot belongs.
Table: Name of the master table.
Link: Database link to the database where the master table resides.
Can Log
Whether or not the snapshot can be logged.
Ref. Group
Associated refresh group.
Last Refreshed
Date the snapshot was last refreshed.
2.
Modify the property sheet parameters as necessary.
3.
Click Apply.
Synonyms Folder
The Synonyms folder contains a list of all synonyms defined within the connected
database.
A synonym is an alias for a table, view, sequence, procedure, function, package or
another synonym.
11-38Oracle Enterprise Manager Administrator’s Guide
Synonyms Folder
Synonyms Multi-Column List