Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Sqlldr constants and dates w/timestamp

Sqlldr constants and dates w/timestamp

From: Marley, Darlene <dmarley_at_sfwmd.gov>
Date: Thu, 28 Oct 2004 12:15:04 -0400
Message-ID: <C7703F708B29884F94752985169E7A7524BDD6@EXCHVS01.ad.sfwmd.gov>


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=19) 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  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 28 2004 - 11:11:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US