Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help exporting tables to flat files

Re: Need help exporting tables to flat files

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 24 Feb 2000 21:58:29 +0100
Message-ID: <951456944.5017.0.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US