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

sqlload, mission impossible ?

From: Salman Mughal <salman_at_netdoor.com>
Date: 1997/01/02
Message-ID: <5afvuj$ja8@axe.netdoor.com>#1/1

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 Thu Jan 02 1997 - 00:00:00 CST

Original text of this message

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