My Oracle Support Banner

Scripts to create Trusted / Untrusted Updateable Snapshot Replication Sites (Doc ID 120094.1)

Last updated on JANUARY 23, 2024

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database - Personal Edition - Version 7.1.4.0 and later
Oracle Database - Enterprise Edition - Version 6.0.0.0 and later
Oracle Database - Standard Edition - Version 7.0.16.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.

Goal

The following article provides an example script generated from the bulletin NOTE:120093.1 for Trusted and Untrusted updateable snapshot replication environments. It does not include examples of the creation of snapshot objects or groups, Oracle Support Services recommends these are created using Replication Manager. A scripted example of the creation of snapshot replication groups and snapshots is included in NOTE:123560.1 for completeness.

For the purpose of this note we will use 8i naming conventions, such as NET8 for the listener and sqlnet configuration. However this article has been tested by Oracle Support for Oracle 9i Net.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.