RE: Sqlldr constants and dates w/timestamp
- From: "Marley, Darlene" <dmarley@xxxxxxxxx>
- To: "Ganesh Raja" <ganesh.raja@xxxxxxxxx>
- Date: Thu, 28 Oct 2004 12:55:52 -0400
Good catch Raja. Removed the ":" and still got the same error. Any
other ideas?
Still bloody in FL.
-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx]
Sent: Thursday, October 28, 2004 12:19 PM
To: Marley, Darlene
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Sqlldr constants and dates w/timestamp
Just a Thought here ..
U have Got ":" in the constrant but the value uh have said as the
NLS_DATE_FORMAT does not havethe ":" in them...
:)
On Thu, 28 Oct 2004 12:15:04 -0400, Marley, Darlene <dmarley@xxxxxxxxx>
wrote:
> Maybe someone can save my bloody head from beating it against the
wall.
>
> I'm using sqlldr 8.1.7 and I'm trying to load a file that needs
> supplemental constant values:
>
> OPTIONS(SKIP=3D19)
>
> LOAD DATA
>
> INFILE 'WCA1MESO.csv'
>
> APPEND
>
> INTO TABLE erid.loaddiel
>
> FIELDS TERMINATED BY "," Optionally enclosed by '"' TRAILING NULLCOLS
>
> (
>
> sonde CONSTANT "33214",
>
> deploydepth CONSTANT ".64",
>
> retrievaldepth CONSTANT ".63",
>
> deploydatetime CONSTANT "04-OCT-2004 14:00:00", -- date format
> DD-MON-YYYY HH24MISS
>
> blah, blah,blah
>
> I've set my environment variable NLS_DATE_FORMAT to 'DD-MON-YYYY
> HH24MISS', but it still pukes on deploydatetime with the error
> "ORA-01830: date format picture ends before converting entire input
> string"
>
> Any ideas?
>
> TIA
>
> Bloody in FL.
>
> I
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
