RE: sql loader problem

From: Singer, Phillip (P.W.) <psinger1_at_ford.com>
Date: Thu, 22 Jul 2004 10:23:02 -0400
Message-ID: <A45063A7D336504580F0161CEB7FEBE201AE7986@na1fcm60.dearborn.ford.com>

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of david wendelken
> Sent: Thursday, July 22, 2004 10:11 AM
> To: oracle-l_at_freelists.org
> Subject: sql loader problem

>=20
>=20
>=20

> I don't use sqlldr very often and I'm having a problem I=20
> don't understand.

>=20

> I'm getting this error: ORA-01460: unimplemented or=20
> unreasonable conversion requested
> I've slogged thru the online sqlldr manual and the error=20
> manual, but I'm not seeing why I'm getting this problem at=20
> all. I've stripped out all the fancy stuff I was trying to=20
> do, just to get the raw basics to work. But no luck!
> Oracle9i Enterprise Edition Release 9.2.0.5.0=20

>=20
>=20

> Control file I'm using:

>=20


> LOAD DATA

>     INFILE '1244.csv'

>     BADFILE '1244.bad'

>     DISCARDFILE '1244.dsc'

>     APPEND

>     INTO TABLE ltest REPLACE

>     FIELDS  TERMINATED BY ","  OPTIONALLY ENCLOSED BY '"'=20

> TRAILING NULLCOLS

>     (DATACALL        INTEGER(2)

>     ,QUESTIONID     INTEGER(10)

>     ,ORGID              INTEGER(10)=20

>     ,ANSWER01        VARCHAR

>     ,ANSWER02        VARCHAR

>     )                           =20


try using
 LOAD DATA
     INFILE '1244.csv'
     BADFILE '1244.bad'
     DISCARDFILE '1244.dsc'
     APPEND
     INTO TABLE ltest REPLACE
     FIELDS  TERMINATED BY ","  OPTIONALLY ENCLOSED BY '"'=20
 TRAILING NULLCOLS
     (DATACALL
     ,QUESTIONID
     ,ORGID
     ,ANSWER01
     ,ANSWER02
     )  =20

All your input data is really 'CHAR' (it is a text file, is it not?), = and that
is the default.

Specifying 'INTEGER' states that your input are binary integers (and if they were, we could not read them in this email).

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jul 22 2004 - 09:20:18 CDT