beautypg.com

Refreshing table snapshots – Oracle A423961 User Manual

Page 102

background image

Admin.

Guide

SQL Ref.

5 – 6

Oracle7 Server Getting Started for Windows NT

you might use the following syntax to redirect the output from the
EXP73 utility:

C:\>EXP73 username/password PARFILE=filename 1>FILE1.LOG

2>FILE2.ERR

In this command line,

FILE1.LOG

receives the standard output from

EXP, while

FILE2.ERR

receives the standard error.

Refreshing Table Snapshots

Oracle7 Server for Windows NT allows you to create copies of a remote
database table.

These copies, referred to as table snapshots, can reside on multiple nodes
of a distributed database. Snapshots allow users to query remote tables
on a local Oracle7 Server, thereby reducing network traffic.

The information in a table snapshot is periodically updated, or
refreshed, to reflect the most recent information in the original table
from which it was created.

Additional Information:

See Managing Table Snapshots in

Oracle7 Server Administrator’s Guide, for information on creating
and managing table snapshots.

Oracle7 Server for Windows NT also creates one or more background
threads called Snapshot Refresh threads, which can periodically refresh
snapshots. Several Snapshot initialization parameters control refresh
threads including:

SNAPSHOT_REFRESH_PROCESSES

SNAPSHOT_REFRESH_INTERVAL

SNAPSHOT_REFRESH_KEEP_CONNECTIONS

Additional Information:

The Oracle7 Server SQL Reference lists

these initialization parameters , their default values, and the
range of acceptable values, as well as providing explanations of
these parameters.

Note:

Snapshot Refresh threads are only available with the

Distributed Option of Oracle7 Server for Windows NT.