Re: HELP how to load ascii-data to oracle???

elwood_at_rumba.m.isar.de (Konstantinos Agouros) wrote:

>Hi,
 

>we have Oracle WG2000 running on a Solaris Intel platform. I need a quick
>way to get some tables filled with data that's provided in lists with field-
>separators like #. What I saw from the loader looked like I can only fill
>if I say this field is so many characters wide. Is this right?

Nope. You can load variable length delimited data too. I've done both TAB delimited and comma separated values ("'s around fields, commas separating them). Here's an example of one of my .CTL files.

OPTIONS (DIRECT=TRUE, ERRORS=9999999)
LOAD DATA
INTO TABLE drug
FIELDS TERMINATED BY X'09'
TRAILING NULLCOLS
(Drug_Code,
Drug_Name)

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!