Need help exporting tables to flat files

Greetings,

I have a need to export a significant number (50+) of large tables (500k - 3M rows) to space padded flat files for processing in a PC/LAN based conversion program. The source is Oracle 7.x on HPUX. I have accomplished this with Datacom on MVS with little problem using Dataquery and some JCL. On the Oracle side I am not finding a convenient method.

The flat files must be space padded (e.g. a VARCHAR3(500) containing 100 bytes must be padded with 400 spaces for a total width of 500 in the ASCII file.) This is a limitation of the comversion environment. Connecting with SQL*Net and ODBC is slower than dirt. Spooling the data from within SQL*Plus has been recommended however that presents the problem of stripping header lines from the resulting file.

The process needs to be reasonably speedy and repeatable as we will be making a number of practice runs.

Any suggestions?

Thanks,

Ken

Ken Taylor
taylorkh_at_mind$pring.com
change the $ to s to reply
unless you are a spammer then... Received on Thu Feb 24 2000 - 14:51:38 CST