Re: sql loader problem
- From: Bricklen Anderson <BAnderson@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 22 Jul 2004 07:23:59 -0700
david wendelken wrote:
> LOAD DATA
> INFILE '1244.csv'
> BADFILE '1244.bad'
> DISCARDFILE '1244.dsc'
> APPEND
> INTO TABLE ltest REPLACE
> FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
> (DATACALL INTEGER(2)
> ,QUESTIONID INTEGER(10)
> ,ORGID INTEGER(10)
> ,ANSWER01 VARCHAR
> ,ANSWER02 VARCHAR
> )
Off the top of my head (not having used sqlldr in a while, is "VARCHAR"
even valid? Maybe try it with "CHAR" instead, or omit the datatypes
altogether.
--
Bricklen Anderson, Database Administrator
PresiNET Systems
http://www.PresiNET.com
Online Demo: https://www.presinet.com/secure/login
_______________________________________________________________________
This e-mail may be privileged and/or confidential, and the sender does
not waive any related rights and obligations. Any distribution, use or
copying of this e-mail or the information it contains by other than the
intended recipient is unauthorized. If you have received this e-mail in
error, please advise me (by return e-mail or otherwise) immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
