流的下游复制更简单

SQL> set numwidth 20

SQL> select dbms_flashback.get_system_change_number() from dual;

DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER()

-----------------------------------------

8331188817820

$> expdp sgreports/sgreports tables=sgreports.test2 directory=expdir logfile=test2.log dumpfile=test2.dmp flashback_scn=8331188817820

On the destination system:

1. As the system user, create the Oracle directory for the export dump file. Make sure the physical directory exists on the filesystem.

2. Copy the export dump file, test.dmp from the source system to /oracle/ora_backup

3. scp test2.dmp oracle@nazar.prc.sun.com:/oracle/ora_backup

3. Import the application schema:

$> impdp system/sys directory=impdir dumpfile=test2.dmp logfile=test2.log

BEGIN DBMS_STREAMS_ADM.ADD_TABLE_RULES( table_name => 'sgreports.test2', streams_type => 'apply', streams_name => 'apply_stream11', queue_name => 'capture_stream1_queue', include_dml => true, include_ddl => true, source_database => 'henry.sun.net', inclusion_rule => true); END; /