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 -> Re: sqlload, mission impossible ?

Re: sqlload, mission impossible ?

From: David Wheatley <wheat_at_globalnet.co.uk>
Date: 1997/01/05
Message-ID: <01bbfb4b$c8ff15a0$82567ec2@comp1>#1/1

Hi

Try replacing 10" with 10 inches

Salman Mughal <salman_at_netdoor.com> wrote in article <5afvuj$ja8_at_axe.netdoor.com>...
>
> It seems like an ordinary sqlload case but me and my friend spent all
 night
> last night trying to figure it out and couldn't.
>
> We have been trying to load a file with lots of lines line the following
:
>
> "423567","I would not touch it with a 10" stick","35",
>
> LOAD
> INFILE 'temp.txt'
> TERMINATED BY ',' ENCLOSED BY '"'
> INTO TABLE testdb
> ( Part_Number ,
> Description ,
> Available )
>
> But keep getting the following error :
>
> No terminator found after TERMINATED and ENCLOSED field
>
> Needless to say we have tried at least a dozen other methods and none
 worked.
> We cant use substr either as we dont know how long the "description"
 field
> will be.
>
> I would appreciate any helpful hints. Thanks a million.
>
> Salman Mughal
> salman_at_netdoor.com
>
Received on Sun Jan 05 1997 - 00:00:00 CST

Original text of this message

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