 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 4 -
Capture
and Propagate Configuration
Capture
Creation – Using create_capture procedure
This procedure performs the following actions:
-
It creates a Capture process called
NY4_CAPTURE. A Capture process with the same name must not exist.
-
It associates the Capture process with an
existing queue named NY4_QUEUE
-
It associates the Capture process with an
existing rule set named NY4_SET1. This is the positive rule set for
the Capture process.
-
It creates a Capture process that captures
local changes to the source database because the source_database
parameter is set to NULL. For a local Capture process, the global
name of the local database for this parameter may also be specified.
Because both the start_scn and the
first_scn are set to NULL, Oracle database determines the
start_scn and first_scn for the Capture process.
If no other Capture processes that capture
local changes are running on the local database, the build procedure
in the dbms_capture_adm package is run automatically. Running
this procedure extracts the data dictionary to the redo log, and a
LogMiner data dictionary is created when the Capture process is
started for the first time.
The next step is to examine the final method by
which the Capture process can be created.
Capture Creation
– Using add_global_rules procedure
Using the add_global_rules procedure of
the dbms_streams_adm package is another way that the database
level changes can be configured.
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
|
|
