How to limit extract base on date condition in oracle goldengate?
MdhtNov 4 2011 — edited Nov 9 2011Hi all,
I have a problem about date condition in extract parameter:
My extract parameter:
GGSCI>edit params ext1
EXTRACT ext1
USERID ggadmin, PASSWORD ggadmin
EXTTRAIL /u01/app/oracle/product/gg/dirdat/lt
DDL INCLUDE MAPPED
table test.chien, where (id >4 and TDATE>TRUNC(TO_DATE('01/01/2011 00:00:00','DD/MM/YYYY HH24:MI:SS')));
when I start extract, have a error:
+7. 2011-11-04 07:06:45 ERROR OGG-01157 Oracle GoldenGate Capture for Oracle, ext1.prm: Error in WHERE clause for TEST.CHIEN.+
I check where condition in the select statement is ok.
I don't know what is different between condition in params of extract and condition in select statement?
Please explaint to me and hepl me how to limit extract capture base date condition,
Thanks so much.
Omni
Edited by: user12378049 on 21:46 03-11-2011