Re: How to export from Oracle to text using Perl

The biggest downside in using SQL*Plus is that SQL*Plus will render the output to the screen. This can be overcome with redirection in a Unix environment though.

Cheers,
Brian

Yong Huang wrote:
>
> tamarr_at_atomica.com (Tamar) wrote in message news:<7282f42a.0306110449.14a5cb06_at_posting.google.com>...
> > We are using Oracle 8.1.7 and were surprised to find that there is no
> > utility to export entire tables to text files. I searched around and
> > found that most people suggested using SQLPlus for this, but I find
> > that its relatively slow and really not efficient with space, since
> > you have to define the line size in advance.
>
> Can you give us your benchmark result? If SQLPlus has trimspool on,
> colsep set to a single character, arraysize set to 100 or so, pagesize
> 0..., I doubt it's slower than your Perl code.
>
> Yong Huang

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"