goldengate 的formatxml输出含有重复的section formatasii一切正常
本帖最后由 dblive 于 2013-7-9 11:03 编辑先说正常的
EXTRACT ext1
SETENV (NLS_LANG = AMERICAN_AMERICA.UTF8)
DBOPTIONS ALLOWUNUSEDCOLUMN
USERID ggs, PASSWORD ggs
TRANLOGOPTIONS, BUFSIZE 4096000
FORMATASCII, NONAMES, DELIMITER '|' ,NOQUOTE , NOHDRFIELDS, NULLISSPACE
EXTFILE /u01/asset.txt, PURGE
table corecat.ASSET ;
这个extract 把表的变化写入 /u01/asset.txt 文件
SQL> insert into asset values(9999991,sysdate);
1 row created.
SQL> commit;
Commit complete.
插入之后，检查，一切正确oracle@neatsorcl:/u01> cat asset.txt
9999991|2013-07-09:02:35:55
系统还有一个extract是生成xml格式的如下：
EXTRACT ext
SETENV (NLS_LANG = AMERICAN_AMERICA.UTF8)
DBOPTIONS ALLOWUNUSEDCOLUMN
USERID ggs, PASSWORD ggs
TRANLOGOPTIONS, BUFSIZE 4096000
FORMATXML,NOINLINEPROPERTIES ,NOTRANS
EXTFILE /n01/oradata2/xmloutput/ext1m.xml, MAXFILES 999999, MEGABYTES 1
table corecat.ASSET ;
这个生成xml格式的extract生成的文件，能看到红色和绿色部分完全一样，请问为什么formatxml生成的文件含有重复部分？如何去除？
<dbupdate>
<table>CORECAT.ASSET</table>
<type>insert</type>
<timestamp>2013-07-09:02:35:58.000000</timestamp>
<columns>
<column>
<name>NDA_ID</name>
<key>true</key>
<value>9999991</value>
</column>
<column>
<name>FIRST_TRADING_DAY</name>
<key>true</key>
<value>2013-07-09:02:35:55</value>
</column>
</columns>
</dbupdate>
<dbupdate>
<table>CORECAT.ASSET</table>
<type>insert</type>
<timestamp>2013-07-09:02:35:58.000000</timestamp>
<columns>
<column>
<name>NDA_ID</name>
<key>true</key>
<value>9999991</value>
</column>
<column>
<name>FIRST_TRADING_DAY</name>
<key>true</key>
<value>2013-07-09:02:35:55</value>
</column>
</columns>
</dbupdate>
GGSCI (neatsorcl) 16> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT 00:00:00 00:00:09
EXTRACT RUNNING EXT1 00:00:00 00:00:09
页:
[1]