Re: Sqlloader: All database in one single plain text file

Mark.Powell_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0402260739.57d4b603_at_posting.google.com>...

> From looking at the notes and example in the 9.2 Utilities manual it
> does not appear that sqlldr is really designed to load different sets
> of data into multiple tables. The only expample takes portions of the
> same input and places it into different tables, but the input data
> format does not change.

Yap.

> It should however be easy to write a C program or Shell script to
> split the input file into one file per table based on the first
> delimited parameter being the table name: fruits.dat, users.dat,
> etc.....

awk is the tool.

But I wanted to know if there was a way to use Oracle-native platform-independent tools...

> Perhaps a true sqlldr expert will see your post and have time to
> respond if there is any practical way to feed multiple layouts to
> multiple tables in a single job.

Thank you anyway!

Best regards from spain. Received on Wed Mar 03 2004 - 18:02:18 CET