OGG源端导出数据

1、查看导出数据大小
[code]select sum(bytes)/1024/1024/1024 from dba_segments where segment_name in ('T_JJ_XMAQJCXX','T_JJ_AQYBZDFX','T_JJ_ZBXX','T_JJ_YZXMBRY','T_JJ_YZXMBJBXX','T_JJ_XMGC','T_JJ_GCSPQK','T_JJ_DTGCJD','T_JJ_DTGC','T_JJ_NDJDJHXF','T_JJ_JSGLDW','T_JJ_DMMX','T_JJ_XMJBXX','T_BNS_PRJM_PROJECT','T_SXM_SHIGRZ','T_SXM_WORKSC','T_SXM_ZHOUYB','T_JJ_XMJDZT','T_BNS_PRJM_CONSTRUTUNIT','T_BNS_PRJM_PROBASINFOSEND','T_BNS_PRJM_PROBASINFOTRAN','T_BNS_PRJM_PROBASINFO','T_CTL_DICTIONARY','T_GATHER_PROJECT_GROUP_DX','T_PDC_ORGANIZATION','T_PGC_OF_PROJECT','T_PGC_OF_PROJECT_LIST','T_STD_YEAR_PLAN');[/code]

2、查看当前SCN号
[code]select CURRENT_SCN from v$database;[/code]

3、导出LPROMIS下的表
[code]EXP LPROMIS/LPROMIS FILE=D:\\JJ_LP.DUMP BUFFER=10240000 FLASHBACK_SCN=00000000000000000 TABLES=T_JJ_XMAQJCXX,T_JJ_AQYBZDFX,T_JJ_ZBXX,T_JJ_YZXMBRY,T_JJ_YZXMBJBXX,T_JJ_XMGC,T_JJ_GCSPQK,T_JJ_DTGCJD,T_JJ_DTGC,T_JJ_NDJDJHXF,T_JJ_JSGLDW,T_JJ_DMMX,T_JJ_XMJBXX,T_JJ_XMJDZT[/code]

4、导出STDPM下的表
[code]EXP STDPM/STDPM FILE= D:\\JJ_ST.DUMP BUFFER=10240000 FLASHBACK_SCN=00000000000000000 TABLES=T_BNS_PRJM_PROJECT，T_SXM_SHIGRZ，T_SXM_WORKSC，T_SXM_ZHOUYB，T_BNS_PRJM_CONSTRUTUNIT，T_BNS_PRJM_PROBASINFOSEND，T_BNS_PRJM_PROBASINFOTRAN，T_BNS_PRJM_PROBASINFO，T_CTL_DICTIONARY，T_GATHER_PROJECT_GROUP_DX，T_PDC_ORGANIZATION，T_PGC_OF_PROJECT，T_PGC_OF_PROJECT_LIST，T_STD_YEAR_PLAN[/code]