How do you create database snapshots in Toad for SQL Server? (4284851)

How do you create database snapshots in Toad for SQL Server?

To Create Snapshot/MView:

- From the Database|Create menu, select Snapshot/M-View

Or

- From the Schema Browser|Snapshots page, click the Create New Snapshot button.

- Click the dropdown button to choose your Schema for the new snapshot.

- Enter the name for the new snapshot in the Name text box.

- Click the Show SQL button (shows the corresponding Create SQL statement)

- You can copy the statement to the clipboard using the Clipboard button or save it using the Save to File button.

- Optionally, add the object to the Project Manager by selecting the Add to PM check box.

- Use the four tabs on the window to enter information about the snapshot in these areas:

The window has 4 tabs:

Snapshot Info
Physical Attributes
Snapshot SubQuery
Partitions
Snapshot Info tab

Cluster check box : If checked, Toad will create the snapshot as part of the cluster specified.

Cluster box : This is where you enter the name of the cluster.

Cluster list box : This displays the cluster columns. You can modify this list with the Add, Edit, and Delete buttons.

Tablespace dropdown : Select the tablespace in which you want your snapshot to be created.

Logging check box : If checked, Toad will log the creation of the snapshot, partition, or LOB storage characteristics in the redo log file.

Cache check box : If checked, data blocks will be placed in the buffer cache when a table scan is performed.

Parallel check box : If checked, the snapshot will be parallelized.

Parallel number box :If the Parallel check box is checked, this input box is enabled. You enter the degree of parallelism (the number of threads used) or you can use the up/down arrows to scroll through the numbers.

Using Index check box : If checked, Toad lets you specify parameters for the snapshot indexes. If this option is checked, the drilldown button is enabled. The drilldown button opens the Physical Attributes window.

Allow Updates check box : If checked, you can update the snapshot (read-write). If unchecked, the snapshot is read-only.

Enable Query Rewrite check box: If checked, the snapshot is enabled for query rewrite.

Build check box :If checked, you can specify when to populate the snapshot. If checked, the radio buttons are enabled. You can choose to build Immediate or build Deferred. Immediate will populate the snapshot immediately. Deferred populates the snapshot during the next refresh.

On Prebuilt Table check box: If checked, the table will be registered to the pre-initialized snapshot. The table and snapshot must have the same name. If checked, the radio buttons are enabled. If you select Without Reduced Precision, the precision of the table or snapshot columns must match exactly with the precision of the subquery results. If you select With Reduced Precision, the precision of the table or snapshot view columns do not have to exactly match the subquery results.

Refresh check box : If checked, you can customize how Oracle will automatically refresh the snapshot. If checked, the refresh options are enabled.

Never Refresh check box : If checked, the snapshot will not automatically refresh.

Refresh Options
Fast -only updates data in the Snapshot Log associated with master/detail table
Complete - re-executes the snapshot view
Force - If fast refresh is possible then it performs a fast refresh, otherwise it performs a complete refresh

On Demand check box : This is mutually exclusive to the On Commit check box. If checked, snapshots will be refreshed on demand.

On Commit check box :This is mutually exclusive to the On Demand check box. If checked, snapshots will refresh automatically during the next commit.

Date Start With : This is mutually exclusive to the Next check box. If checked, you can use the dropdown to pull up a calendar where you select a date for the first automatic refresh time.

Next :This is mutually exclusive to the Start With check box. If checked, you can use the dropdown to pull up a calendar where you select a date to calculate intervals between auto refreshes.

With
Primary Key radio button : If selected, a primary key snapshot will be created.
Rowid radio button : If selected, a rowid snapshot will be created.
Rollback Segment check box :This lets you specify the rollback segment to use. If checked, it enables the Master and Local radio buttons.
Master radio button :If the Rollback Master option is selected, the remote rollback segment will be used at the remote master for the snapshot.
Local radio button :If the Rollback Local option is selected, the remote rollback segment will be used for the snapshot that is in the local refresh group.
Default Segment check box : If checked, the snapshot will use the default rollback segment. If unchecked, the Rollback Segment box is enabled.
Rollback Segment box :This is enabled if the Default Segment check box is unchecked. You type in the rollback segment that will be used.

Physical Attributes tab :The physical attributes tab contains dropdowns and value boxes that let you define physical options such as percent free, storage extents, and buffer pool.

Snapshot/MView Subquery tab: This lets you enter the subquery that is to be used to generate the snapshot.

Partitions tab : In order for this tab to be enabled you must enter a valid subquery into the snapshot subquery tab. You select columns from the Available Columns list to determine which columns the partition will be based upon. Double-click the column name or click the column and click the single right arrow to move the selected columns into the Partitions Columns list.

Add a Partition : Once you select columns for the partitions to be based upon, you can then add a partition.

Range Partitions For range partitions, you do this by clicking the Add button. The Add Partition dialog box appears, and you can provide a partition name. You must enter the upper range for each column within the partition, or select Maxvalue from the dropdown list on that dialog box.

Note: String value upper bounds must be enclosed in single quotes within the grid (for example, for a Last Name column with a datatype of varchar2, an upper bound could be 'Smith'). The single quotes must be entered into the grid.
Hash Partitions To add a hash partition, select the Hash Partitions tab at the bottom of the dialog box, and then move the tablespaces to use for the hash partition into the partition area.

Subpartitions You can also add a subpartition to either hash or list.