Re: Need help exporting tables to flat files

Thanks! With the input I have received from this wonderful group I will be spooling today!

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>set pagesize 0 heading off
>to have no headers in sql*plus.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>Ken Taylor <taylorkh_at_mind$pring.com> wrote in message
>news:38b5966c.293217875_at_news.mindspring.com...
>> 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 Fri Feb 25 2000 - 05:04:39 CST