Prerequisites and Restrictions
Read-only snapshots do not require the advanced
replication facilities. You must, however, have the Procedural Option
installed (i.e., the catalog script
catproc.sql
must have been run), and the scripts
dbmssnap.sql
and prvtsnap.plb
must have been run. (Oracle runs these scripts
automatically when you install the Procedural Option by running
catproc.sql
.) You also must set initialization
parameters and grant appropriate system privileges to accounts that
create snapshots.
Initialization Parameters
In order for snapshots to be capable ofrefreshing automatically, you must set the following initialization parameters:
- JOB_QUEUE_PROCESSES
This parameter should be set to at least 1. The default is 0.
- JOB_QUEUE_INTERVAL
This parameter should be set to a value that is less than or equal to your most frequent snapshot interval. The default is 60; the units are seconds.
System Privileges
The following system privileges are associated with snapshot administration:
- ALTER ANY SNAPSHOT
The grantee can change various properties of snapshots in any schema. You should reserve this privilege for DBA accounts; it is granted to the DBA role when the database is created.
- CREATE ANY SNAPSHOT
The grantee can create a snapshot in any schema. You should reserve this privilege for DBA accounts; it is granted to the roles DBA and IMP_FULL_DATABASE when the database is created.
- CREATE DATABASE LINK
The grantee can create and drop private database links. Technically, this privilege is not ...
Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.