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 -> sqldr -- help

sqldr -- help

From: Andriy Shafar <cutwater_at_wp.pl>
Date: Mon, 2 May 2005 21:57:31 +0200
Message-ID: <d560n9$kka$1@galaxy.uci.agh.edu.pl>


Hi.

I have some problem.

I do:

  1. create table _table (id number, column_1 varchar(4000));
  2. file.ctl -> load data INFILE "file.DAT" INTO TABLE _table FIELDS TERMINATED BY '|';
  3. file.dat -> 1|Very long text, but less then 4000 characters.
  4. I run sqlldr and in file.log I have: the row in file is to long. But I have 860char. in my row.

What can I do to fix that?

Thanks

-- 
Andriy Shafar
Received on Mon May 02 2005 - 14:57:31 CDT

Original text of this message

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