dbTalk Databases Forums  

Re: NLS_DATE_FORMAT with SOL Loader

Go Back dbTalk Databases Forums Databases comp.databases.oracle Re: NLS_DATE_FORMAT with SOL Loader

comp.databases.oracle comp.databases.oracle


Discuss Re: NLS_DATE_FORMAT with SOL Loader in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Simeon Dimitrov
 
Posts: n/a

Default Re: NLS_DATE_FORMAT with SOL Loader - 06-25-2003 , 01:24 AM





Hi
If you are running UNIX edit your .profile file and set
NLS_LANG=AMERICAN_AMERICA.US7ASCII according your local setting. In
Windows set this parameter in the windows registry. After that you
must sepcify the date format in the control file of the sqlldr in this
whay
filed1 DATE "YYYYMMDDHH24MISS", filed2 ...
Enjoy

fareeda (AT) pspl (DOT) co.in (fareeda) wrote in message news:<c6d78d84.0306230548.3c54cad2 (AT) posting (DOT) google.com>...
Quote:
hi,

I am trying to set the NLS_DATE_FORMAT to be used by 'sqlldr' (Since
my date format is not the default)
But it fails to take effect.

Also, I cannot set the DATE format in the column list in the sqlldr
control file since it is an autogenerated.
The control file is generated internally and passed to sqlldr.

I tried this:
1) export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
2) checked in ENV and it seems to be there
3) run sqlldr to load the data which is present in above format

Result: no data is loaded, giving DATA error messages.

Is there a way to set the date format to be used by sqlldr (other than
in control file)

Any pointer would help.
Thanks
Fareeda

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top