This content has been marked as final. Show 2 replies
Many databases handle spaces and empty spaces differently, and it can also depend on the datatype. For example, in some cases, variable length strings will not keep trailing spaces, or just a single space. Some datatypes, like CHAR, will keep spaces and padding. From the source database, you will need to determine how those data types are handled in the source database. If they are maintained, then GoldenGate will maintain them in the trail file as well. However, when OGG goes to apply them to the target database, the target database settings will take precedence.
Since I'm not sure which datatypes or exact databases you are replicating to or from, I can't be of much help on specifics, but I would advise you to look at the [NO]SPACESTONULL parameter too.
i have written it in my question that i am transfering it from sqlserver2005 to oracle 11g express.
NOSPACESTONULL is default it is also making empty to null
SPACESTONULL makes empty and spaces to null in varchar2
Edited by: 944768 on Jan 9, 2013 8:24 PM
Edited by: 944768 on Feb 3, 2013 11:36 PM