My Oracle Support Banner

Replicat Losing Precision With replication From Sybase Float To Oracle Number (Doc ID 1341215.1)

Last updated on APRIL 03, 2019

Applies to:

Oracle GoldenGate - Version 10.4.0.19 and later
Information in this document applies to any platform.
NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Symptoms

The replicat is only updating/inserting 16 significant digits(before and after the decimal point) when replicating sybase float to oracle number(without Precision) when the source float numbers have 17 (or more) significant digits

Eg  Sybase Float 566776357.6548000574111938
      After replication to Oracle Number  566776357.6548001

Sybase Float  900000.0670000000391155
      After replication to Oracle Number   900000.067 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.