Re: Export To SQL*Loader

From my experience, SQL*Loader
with direct option is the best
But you can only load table data
and you have to create indexes,
constraints later.

You can write some Pro*C programs to
dump data to files whatever format you want

HTH Madhu Cherukuri

John Mccoll wrote in message <35E840CE.C204A412_at_home.com>...
>I'm relatively new to the Oracle world and would like to know if there
>is any software available which takes an Export file and creates both
>the SQL*loader control file and the corresponding input file. I wish to
>benchmark the elapsed times vs import. I have a very small window
>available to do table reorgs and need to optimize the process.
>
>Thanka in advance
>John McColl
Received on Mon Aug 31 1998 - 19:38:18 CDT