 |
|
ss
Oracle Tips by Burleson |
Oracle Streams
Chapter 4 -
Capture
and Propagate Configuration
Create the Schema
at Source Database
The next step is to create schema/users named
NY1, NY2, NY3, and NY4 where tables will be created. After the
schema/users have been created, the objects will be used to
demonstrate the replication process using the Streams technology.
Setup_NY1.sql, which is available in the code depot, lists SQL
statements that create the necessary tablespace, schema, tables and
sequence for the Schema NY1. Similarly, objects can also be created
in NY2, NY3, and NY4.
The creation of tables will be repeated later
in the additional schemas NY2, NY3 and NY4 to demonstrate some other
options with which the Streams flow can be configured.
Set up the Supplemental Logging
As presented earlier, the process of logging
extra columns to the redo log files is called supplemental logging.
It is not a default behavior. It has to be enabled at either the
database level or at the object level.
Using the primary key for the supplemental
logging causes the database to place all columns of a row's primary
key in the redo log file whenever a row containing a primary key is
updated. This will occur even if no value in the primary key has
changed.
The following SQL statements show the set up of
supplemental logging at the table level for the table named
ALLINSURED1, using the primary key.
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
