The environment variable NLS_DATA_FORMAT can be used to define date format of data in input file (holding text data). The oracle manual mentioned this point in "DIRECT PATH LOAD" session.
Mostly, the data conversion from client side to server can define better in control files rather than depending on this environment variable.
But, the behavior of sqlldr differs between WINDOWS and UNIX clients.
In UNIX, we have to use this option "DIRECT=true" of sqlldr to get effect of using NLS_DATE_FORMAT environment variable.
In Windows, no need to be using "DIRECT" loading option, still conventional loading also take account of this environment variable to define the date format of value in input file.
When you convert a script from Windows to UNIX platform which performs data loading by using sqlldr, then this information will be really helpful.
0 comments:
Post a Comment