Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help exporting tables to flat files
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 Thu Feb 24 2000 - 14:58:29 CST