Not Using the Database Link
For example, use the following SQL block to
perform the data dictionary build:
SET SERVEROUTPUT ON
DECLARE
scn NUMBER;
BEGIN
DBMS_CAPTURE_ADM.BUILD( first_scn => scn);
DBMS_OUTPUT.PUT_LINE('First SCN Value = '
|| scn);
END;
This procedure displays the valid
first_scn value, 155781561, for the Capture process that
will be created at the Down Streams database. Jot down the SCN
value from above step. This value will be used when creating the
Capture process at the Down Streams database.
Next, prepare the required table for
instantiation. For example run the following SQL block to
instantiate the table ALLINSURED1:
BEGIN
DBMS_CAPTURE_ADM.PREPARE_TABLE_INSTANTIATION(
table_name =>
'NY1.allinsured1');
END;
/
