Re: Need help exporting tables to flat files

Thanks! I will give it a try.

johng_at_mm.com (TurkBear) wrote:

>
>To avoid post-processing of the spooled file, use the SET commands in SqlPlus to
>turn off heading, feedback, etc..
>
>You may want to try a reporting tool that exports( Like Crystal reports) - one
>of the options is fixed-format so that a varchar2(500) will occupy 500 spaces
>regardless of content length...
>
>
>taylorkh_at_mind$pring.com (Ken Taylor) wrote:
>
>>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...
>
>
>
>-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
>http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
>-----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Thu Feb 24 2000 - 17:16:15 CST