monster beats by dr. dre oracle 10g Streams enviro -

hkdty228

6, configured in racdb2 apply - application process
conn strmadmin / strmadmin
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES (
schema_name => 'hr',
streams_type => 'apply',
streams_name => 'apply_racdb2',[link widoczny dla zalogowanych],
queue_name => 'strmadmin.racdb2_queue',
include_dml => true,
include_ddl => true,
source_database => ' racdb1 ');
END;
/

set disable error,[link widoczny dla zalogowanych],[link widoczny dla zalogowanych], when an error occurs apply process does not stop
conn strmadmin / strmadmin
BEGIN
DBMS_APPLY_ADM.SET_PARAMETER (
apply_name => 'apply_racdb2',
parameter => 'disable_on_error',
value => 'n');
END;
/

7, in racdb2 start the apply process
conn strmadmin / strmadmin
BEGIN
DBMS_APPLY_ADM.START_APPLY (
apply_name => 'apply_racdb2');
END;
/

8, start the capture process in racdb1
conn strmadmin / strmadmin
BEGIN
DBMS_CAPTURE_ADM.START_CAPTURE (
capture_name => 'capture_racdb1');
END;
/
Note : propagation process is created by default from the start, that did not start to manually start :
BEGIN
DBMS_PROPAGATION_ADM.START_PROPAGATION (
propagation_name => 'racdb1_to_racdb2');
END;
/

ok,[link widoczny dla zalogowanych], stop here , streams have been configured . Adopted in the racdb1 hr user performs related ddl, dml operation, the results can be seen on the racdb2 .

IV summarizes the main
above steps are given in detail , without adding too many notes, please refer to the conceptual things oracle documentation. Personal feeling to master a new technology is better : google specific article , but because of the environment vary widely , in all likelihood be unreasonable ; then carefully study the document oracle , E wen we all looked tired, but this is the most More , the most comprehensive ; perseverance, find ways to get it, may two or three hours ,beat by dre headphone 2009 intrepid, probably two or three days ,[link widoczny dla zalogowanych], may also be two or three weeks , but must do it , drop out is to destroy confidence .

				fora.pl - załóż własne forum dyskusyjne za darmo Powered by phpBB © 2001, 2002 phpBB Group Avalanche style by What Is Real © 2004