Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got replicate v6.6 546 for some customer capture process issue but it have Full load bug
I tested full load task from oracle and oracle ,File and other with replicate v6.6 546.
I think it have bug of date type column.
Source data time is PM 2:02:23 But target data time is PM 2:02:02.
I had same testing with v6.6.0.488 it is no problem.
update]
I've got v6.6 sp8 (v6.6.0.571) I think this issue is fixed.
Oracle Source
DATE columns would be truncated during Full Load when the bindDateAsBinary internal parameter was set to false.
2118265 RECOB-1649
Hello @khchoy ,
Well done! you are facing a defect indeed, thanks for your good insight!
Just like you said (support case #02133176#), the defect occurs in a few of builds of 6.6, eg SP07 (546). You can use higher builds eg 6.6 SP08 and up, or previous builds eg 6.6 SP04 and low. This fix will be included in 7.1 (April 20201) too
The defect fix was mentioned in 6.6 SP08 patch release notes:
Oracle Source
DATE columns would be truncated during Full Load when the bindDateAsBinary internal parameter was set to false.
2118265
RECOB-1649
Regards,
John.