extract ei tt Seteny(NLS LANG =AMERICAN AVMERICA.WE8IS08859P1)
Betenv(ORACLE HOME="/u01/app/oracle/product/9.2.0/db_1")
setenv(ORACLESID="racl")
cuserid XXX,password XXXREPORT AT 01:59
reportrollover at 02:00
exttrail/u01/ggs/dirdat/ext in/test/tt
numfiles 500
NOCOMPRESSDELETES
tranlogoptions archivedlogonly tranlogoptions
altarchivelogdest instance racl/db archivelog/shestate,altarchivelogdest instance rac2/db archivelog/shestate
table domaintain.test_12,COLSEXCEPT(OWNER,OBJECT NAME):
我在源端的抽取进程配置了COLSEXCEPT,但是在目标端还是没有过滤掉这两个字段,有人知道什么原因吗
Betenv(ORACLE HOME="/u01/app/oracle/product/9.2.0/db_1")
setenv(ORACLESID="racl")
cuserid XXX,password XXXREPORT AT 01:59
reportrollover at 02:00
exttrail/u01/ggs/dirdat/ext in/test/tt
numfiles 500
NOCOMPRESSDELETES
tranlogoptions archivedlogonly tranlogoptions
altarchivelogdest instance racl/db archivelog/shestate,altarchivelogdest instance rac2/db archivelog/shestate
table domaintain.test_12,COLSEXCEPT(OWNER,OBJECT NAME):
我在源端的抽取进程配置了COLSEXCEPT,但是在目标端还是没有过滤掉这两个字段,有人知道什么原因吗