Re: Loading external data without specifying column names

Chrean wrote:
> Hello folks,
> I'd need to do exactly what I wrote in subject.
> Starting from a set of txt files, each containing data to be loaded in
> my oracle db's tables, I have to write a script that loops on each file
> and load it into the db.
> I tried with sqlldr, but it requires that I specify every column name.
> I don't want to do that, 'cause my routine will always find a match
> between db columns and datafiles fields.
>
> Correct syntax is:
>
> load data
> infile 'example.dat' "fix 11"
> into table example
> fields terminated by ',' optionally enclosed by '"'
> (col1, col2)
>
> while I'd want something like this:
>
> load data
> infile 'example.dat' "fix 11"
> into table example
> fields terminated by ',' optionally enclosed by '"'
>
> 'cause I already know my table will have 2 columns (and my datafile
> will always have 2 fields, of course), not necessarily named "col1",
> "col2".
>
> Thanks in advance,
> Chrean
>

Have you considered External Tables? This still uses the SQL*Loader engine, so you will still have to perform some dynamic creation here for your input file as suggested earlier in this thread. But you can create a script to scan the input file and dynamically generate the CREATE TABLE..ORGANIZATION EXTERNAL command for you. Then the data becomes available as if it were a table in your database. This may or may not help you...

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown