Not Using the Database Link
The Capture process where
use_database_link is set to FALSE can be created as shown
below.
BEGIN
DBMS_CAPTURE_ADM.CREATE_CAPTURE(
queue_name => 'ln1_queue',
capture_name
=> 'ln1_capture',
rule_set_name => NULL,
start_scn => NULL,
source_database => 'dbs1.net',
use_database_link => false,
first_scn =>
155781561, -- Use value from build
proc
logfile_assignment => 'implicit');
END;
/
The first_scn for the Capture
process has been specified. This value was obtained earlier at
the source database. The first_scn is the lowest SCN for
which a Capture process can capture changes.
Note: Since a first_scn is
specified, the Capture process creates a new LogMiner data
dictionary when it is first started, regardless of whether there
are existing LogMiner data dictionaries for the same source
database.
