Oracle Distributed Systems

Getting Started

Before setting up tables for replication, you must complete the preliminary tasks described in Chapter 10. These tasks include the following:

• Determining and setting initialization parameters appropriately

• Sizing rollback segments and redo logs

• Running catproc.sql and catrep.sql (and optionally catrepad.sql )

• Creating administrative accounts with appropriate privileges

• Creating necessary database links

If you have accomplished these tasks, you are ready to create replication groups, configure tables, and other objects for replication and add master databases.

The Quick-and-Dirty Setup

Many people want to configure objects for replication as quickly and simply as possible so that they can get a sense of the administration and performance considerations and to learn about how replication works firsthand. To speed these people on their way, the steps required to set up a bare-bones replicated environment are included here. The main distinction between thisminimal configuration and one that is appropriate for production is that it does not include any conflict resolution logic.

Warning

Although these steps will indeed create a replicated environment, it is not suitable for a production installation because it does not take conflicts into account, rendering it anything but robust.

This procedure assumes that you have set the proper initialization parameters, run the required catalog scripts, and created necessary database links and administrative accounts. Now, with no further ado, ...