Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> sqlload, mission impossible ?
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