 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 4 -
Capture
and Propagate Configuration
Capture
Creation - Using add_schema_rules procedure
BEGIN
iscn :=
DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
dbms_output.put_line ('Instantiation SCN : '
|| iscn ) ;
DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN@DNYOIP20.world
(
source_schema_name => 'ny2',
source_database_name => 'DNYTST10.world',
instantiation_scn => iscn ,
recursive => true
);
END;
/
Start both the Apply and Capture processes at
the destination and source databases, respectively:
connect STRMADM/STRMADM@dnyoip20
PROMPT Connected to Destination (DNYOIP20)
PROMPT Starting the Apply Process at
Destination
begin
dbms_apply_adm.start_apply (apply_name =>
'LN2_APPLY ' ) ;
end ;
/
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
|
|
