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

Home -> Community -> Usenet -> c.d.o.misc -> sql*loader and Date

sql*loader and Date

From: swaxolez <willem_at_pcfish.ca>
Date: 18 May 2006 19:26:51 -0700
Message-ID: <1148005611.878069.274720@u72g2000cwu.googlegroups.com>


I'm trying to load a csv file into a table and keep having the following error pop up:

Record 1: Rejected - Error on table HYDDATA, column Cr_DATE. ORA-01847: day of month must be between 1 and last day of month

My Control File is:

LOAD DATA
 INFILE A2.CSV
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE HYDDATA
 FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'  TRAILING NULLCOLS (
  Cr_Date DATE (10) "DD/MM/YY",
  Cr_Time,
  PSI,
    GEOMETRY COLUMN OBJECT
   (

     SDO_POINT COLUMN OBJECT
       (X            FLOAT EXTERNAL,
        Y            FLOAT EXTERNAL)

   ),
   Longitude,
   Latitude,
  Heading,
  Speed,
  Mode,
  Action,
  ID

)

and my input data is of the following format:

30/04/2006,16:01:54,806,-121.6359816,34.4566166,157.1,0,0,0,1

Any help would be greatly appreciated.

Thanks Received on Thu May 18 2006 - 21:26:51 CDT

Original text of this message

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