Hi there,
Of late, we are experiencing a strange problem with sql*loader. It is populating some columns with values that are not in the raw file. For example., the raw file contains
XXXXXXXX |99999999|436|||||||||||||||
XXXXXXXX |44444444|311|||||||||||||||
XXXXXXXX |33333333|042|||||||||||||||
XXXXXXXX |55555555|515|||||||||||||||
XXXXXXXX |66666666|585|||||||||||||||
the value gets inserted as
XXXXXXXX, 99999999, 460001
XXXXXXXX, 33333333, 005100
XXXXXXXX, 55555555, 580100
XXXXXXXX, 66666666, 516049
You can see clearly the value 460001, 005100, 580100 and 516049 are not in the raw file.
The columns in the staging table are all varchar2(2000) to provide for free loading and then edit before loading into the production tables.
This problem happens sporadically and when it does, it causes a lot of havoc and production is down for hours.
The production environment id Oracle 9.2.0.4 and the OS is Red Hat Linux. If any of you gurus have come across such an issue would you please throw some light on what's happening and how do we resolve this ?
Thanks
Vds
Of late, we are experiencing a strange problem with sql*loader. It is populating some columns with values that are not in the raw file. For example., the raw file contains
XXXXXXXX |99999999|436|||||||||||||||
XXXXXXXX |44444444|311|||||||||||||||
XXXXXXXX |33333333|042|||||||||||||||
XXXXXXXX |55555555|515|||||||||||||||
XXXXXXXX |66666666|585|||||||||||||||
the value gets inserted as
XXXXXXXX, 99999999, 460001
XXXXXXXX, 33333333, 005100
XXXXXXXX, 55555555, 580100
XXXXXXXX, 66666666, 516049
You can see clearly the value 460001, 005100, 580100 and 516049 are not in the raw file.
The columns in the staging table are all varchar2(2000) to provide for free loading and then edit before loading into the production tables.
This problem happens sporadically and when it does, it causes a lot of havoc and production is down for hours.
The production environment id Oracle 9.2.0.4 and the OS is Red Hat Linux. If any of you gurus have come across such an issue would you please throw some light on what's happening and how do we resolve this ?
Thanks
Vds