Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help exporting tables to flat files
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 - 15:23:21 CST