--

-- expdp data

--

--此处获得的scn值要当作于expdp的FLASHBACK_SCN参数值, 这样导入数据到目标库后就会实例化scn.

SQL> select dbms_flashback.get_system_change_number() scn from dual;

--4280457778

SQL> !rm /u06/backup/source/erating.*

SQL> !expdp strmrep/xxx SCHEMAS=encle,scott directory=dir_source dumpfile=erating.dp FLASHBACK_SCN=4280457778

SQL> !scp /u06/backup/source/erating.dp 172.16.1.175:/u01/backup/dest/

--

-- Start capture process CAP_ERATING

--

SQL> GIN

   dbms_capture_adm.start_capture(

     capture_name => 'CAP_ERATING');

EXCEPTION WHEN OTHERS THEN

   IF sqlcode = -26666 THEN NULL;   -- CAPTURE process already running

   ELSE RAISE;

   END IF;

END;

/

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

-- connect as streams administrator to destination site

CONNECT strmrep/xxx@db_yitian

--

-- create tablespaces, 先把目标库对应的表空间建立上, 不然无法导入数据

--

SQL> CREATE TABLESPACE ERATING_USER01 DATAFILE

   '/u01/oradata/YITIAN/erating_user01.dbf' SIZE 4096M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED,

SEGMENT SPACE MANAGEMENT AUTO;

SQL> CREATE TABLESPACE ERATING_LOG01 DATAFILE

   '/u01/oradata/YITIAN/erating_log01.dbf' SIZE 4096M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED,

SEGMENT SPACE MANAGEMENT AUTO;

SQL> CREATE TABLESPACE ERATING_INDEX01 DATAFILE

   '/u01/oradata/YITIAN/erating_index01.dbf' SIZE 2048M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED,

SEGMENT SPACE MANAGEMENT AUTO;

--

-- impdp data

--

SQL> !impdp strmrep/xxx directory=dir_dest dumpfile=erating.dp remap_schema="scott:scottnew"