简化了的建立流的步骤！

三个过程搞定流：

1。

ACCEPT strm_pwd_src PROMPT 'Enter Password of Streams Admin "strmadmin" at Source : ' HIDE
ACCEPT strm_pwd_dest PROMPT 'Enter Password of Streams Admin "strmadmin" at Destination : ' HIDE
ACCEPT schema_name PROMPT 'Enter Schema name you want to replicate to the target:'
ACCEPT target_db_name PROMPT 'Enter Target db name:'
connect "STRMADMIN"/&strm_pwd_src;
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name => '"&schema_name"',
streams_type => 'capture',
streams_name => '"STREAMS_CAPTURE"',
queue_name => '"STRMADMIN"."STREAMS_CAPTURE_Q"',
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
inclusion_rule => true);
END;
/
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_PROPAGATION_RULES(
schema_name => '"&schema_name"',
streams_name => '"STREAMS_PROPAGATION"',
source_queue_name => '"STRMADMIN"."STREAMS_CAPTURE_Q"',
destination_queue_name => '"STRMADMIN"."STREAMS_APPLY_Q"@&target_db_name',
include_dml => true,
include_ddl => true,
source_database => 'LAB10G.CENTRAL',
inclusion_rule => true );
END;
/
COMMIT;
connect "STRMADMIN"/&strm_pwd_dest@"&target_db_name";
BEGIN
DBMS_STREAMS_ADM.ADD_SCHEMA_RULES(
schema_name => '"&schema_name"',
streams_type => 'apply',
streams_name => '"STREAMS_APPLY"',
queue_name => '"STRMADMIN"."STREAMS_APPLY_Q"',
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
inclusion_rule => true);
END;
/

2。

ACCEPT strm_pwd_src PROMPT 'Enter Password of Streams Admin "strmadmin" at Source : ' HIDE
ACCEPT strm_pwd_dest PROMPT 'Enter Password of Streams Admin "strmadmin" at Destination : ' HIDE
ACCEPT schema_name PROMPT 'Enter Schema name you want to replicate to the target:'
ACCEPT target_db_name PROMPT 'Enter Target db name:'
ACCEPT source_db_name PROMPT 'Enter Source db name:'
connect STRMADMIN/&strm_pwd_dest@&target_db_name;
set serverout on;
DECLARE
handle1 number;
ind number;
percent_done number;
job_state VARCHAR2(30);
le ku$_LogEntry;
js ku$_JobStatus;
jd ku$_JobDesc;
sts ku$_Status;
BEGIN
handle1 := DBMS_DATAPUMP.OPEN('IMPORT','SCHEMA', '&source_db_name');
DBMS_DATAPUMP.ADD_FILE(handle1, 'StreamImport_1246301109502.log', 'STREAMS_DIR_RPT10G', '', DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE)
;
dbms_datapump.set_parameter(handle =>handle1, name => 'FLASHBACK_TIME', value => 'TO_TIMESTAMP (to_char(sysdate,''dd.mm.yyyy HH2
4:MI:SS''),''dd.mm.yyyy HH24:MI:SS'')');
DBMS_DATAPUMP.METADATA_FILTER(handle1, 'SCHEMA_EXPR', 'IN (''&schema_name'')');
DBMS_DATAPUMP.SET_PARAMETER(handle1, 'INCLUDE_METADATA', 1);
DBMS_DATAPUMP.START_JOB(handle1);
percent_done :=0;
job_state := 'UNDEFINED';
while (job_state != 'COMPLETED') and (job_state != 'STOPPED') loop
dbms_datapump.get_status(handle1, dbms_datapump.ku$_status_job_error + dbms_datapump.ku$_status_job_status + dbms_datapump.ku$_sta
tus_wip,-1,job_state,sts);
js := sts.job_status;
if js.percent_done != percent_done
then
dbms_output.put_line('*** Job percent done = ' || to_char(js.percent_done));
percent_done := js.percent_done;
end if;
if(bitand(sts.mask, dbms_datapump.ku$_status_wip) != 0)
then
le := sts.wip;
else
if(bitand(sts.mask,dbms_datapump.ku$_status_job_error) != 0)
then
le := sts.error;
else
le := null;
end if;
end if;
if le is not null
then
ind := le.FIRST;
while ind is not null loop
dbms_output.put_line(le(ind).LogText);
ind := le.NEXT(ind);
end loop;
end if;
end loop;
dbms_output.put_line('Job has completed');
dbms_output.put_line('Final job state = ' || job_state);
dbms_datapump.detach(handle1);
END;
/

3。

ACCEPT strm_pwd_src PROMPT 'Enter Password of Streams Admin "strmadmin" at Source : ' HIDE
ACCEPT strm_pwd_dest PROMPT 'Enter Password of Streams Admin "strmadmin" at Destination : ' HIDE
ACCEPT schema_name PROMPT 'Enter Schema name you want to replicate to the target:'
ACCEPT target_db_name PROMPT 'Enter Target db name:'
ACCEPT source_db_name PROMPT 'Enter Source db name:'
connect "STRMADMIN"/&strm_pwd_dest@"&target_db_name";
set serverout on;
DECLARE
v_scn NUMBER;
BEGIN
v_scn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN(
SOURCE_SCHEMA_NAME => '&schema_name',
source_database_name => '&source_db_name',
instantiation_scn => v_scn,
RECURSIVE => true );
END;
/
DECLARE
v_started number;
BEGIN
SELECT DECODE(status, 'ENABLED', 1, 0) INTO v_started
FROM DBA_APPLY where apply_name = 'STREAMS_APPLY';
if (v_started = 0) then
DBMS_APPLY_ADM.START_APPLY(apply_name => '"STREAMS_APPLY"');
end if;
END;
/
connect "STRMADMIN"/&strm_pwd_src;
set serverout on;
DECLARE
v_started number;
BEGIN
SELECT DECODE(status, 'ENABLED', 1, 0) INTO v_started
FROM DBA_CAPTURE where CAPTURE_NAME = 'STREAMS_CAPTURE';
if (v_started = 0) then
DBMS_CAPTURE_ADM.START_CAPTURE(capture_name => '"STREAMS_CAPTURE"');
end if;
END;
/
BEGIN
DBMS_OUTPUT.PUT_LINE('*** Progress Message ===> Started the capture process STREAMS_CAPTURE at source database LAB10G.central and th
e apply process STREAMS_APPLY at the destination database successfully. ***');
END;
/