1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
strmadmin@OR11203B>begin
dbms_streams_adm.maintain_schemas(
schema_names => 'TEST_SCHEMA',
source_directory_object => null,
destination_directory_object => null,
source_database => 'OR11203A.LOCAL',
destination_database => 'OR11203B.LOCAL',
capture_name => 'CAPTURE',
capture_queue_table => 'STREAMS_QUEUE_QT',
capture_queue_name => 'STREAMS_QUEUE',
apply_name => 'APPLY',
apply_queue_table => 'STREAMS_QUEUE_QT',
apply_queue_name => 'STREAMS_QUEUE',
include_ddl=>true,
instantiation=>dbms_streams_adm.instantiation_schema_network
);
end;
/
job finished
Procédure PL/SQL terminée avec succès.
strmadmin@OR11203B>begin
dbms_capture_adm.set_parameter(
capture_name => 'CAPTURE',
parameter => 'downstream_real_time_mine',
value => 'Y');
end;
/
Procédure PL/SQL terminée avec succès.
sys@OR11203A> alter system archive log current;
Système modifié. |
Partager