 |
|
ss
Oracle Tips by Burleson |
Oracle Streams
Chapter 8 -
Down Streams Capture
Step 2: Setup Up Supplemental Logging at
Source Database
At the source database, specify primary key
supplemental logging for the table desired. For example, to specify
logging information for the table ALLINSURED1, the following SQL
statement can be run:
ALTER TABLE NY1.allinsured1
ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY)
COLUMNS;
Step 3: Create Queue and Capture process
The next step is to create the queue and the
Capture process at the Down Streams database. There are two methods
that can be used to create the Capture process. One is to create the
Capture process where the database link to source database is
specified, and the other method is to not use the database link.
For example, by using the following SQL block a
Capture process will be created where database link to source
database is specified:
BEGIN
DBMS_CAPTURE_ADM.CREATE_CAPTURE(
queue_name => 'LN1_queue',
capture_name =>
'LN1_capture',
rule_set_name =>
NULL,
start_scn => NULL,
source_database =>
'DNYTST10.world',
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
|
|
