SQLLoader Syntax - help me with control file format

From: <calistab_at_my-deja.com>
Date: Mon, 01 Nov 1999 23:07:12 GMT
Message-ID: <7vl6eu$pp1$1@nnrp1.deja.com>

I need to load a *HUGE* text file that is comma delimited with text qualifiers (" ") into an Oracle Table. Previously I had written my loader scripts with field specifications like this:

FIELDS TERMINATED BY',' OPTIONALLY ENCLOSED BY " " I'd like to take out the OPTIONALLY since if I leave it in, fields with commas in them get parsed into different fields. Oracle documentation appears to allow this, but when I try to write it like this,

FIELDS TERMINATED BY',' ENCLOSED BY " " I get this error: Initial enclosure character not found

What am I doing wrong? What is the proper syntax for loading this type of data? Many Thanks. Calista

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Nov 01 1999 - 17:07:12 CST