NLS_DATE_FORMAT with SOL Loader
From: fareeda <fareeda_at_pspl.co.in>
Date: 23 Jun 2003 06:48:58 -0700
Message-ID: <c6d78d84.0306230548.3c54cad2_at_posting.google.com>
Date: 23 Jun 2003 06:48:58 -0700
Message-ID: <c6d78d84.0306230548.3c54cad2_at_posting.google.com>
hi,
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
Received on Mon Jun 23 2003 - 15:48:58 CEST