Re: How to export from Oracle to text using Perl

From: Yong Huang <yong321_at_yahoo.com>
Date: 11 Jun 2003 11:21:20 -0700
Message-ID: <b3cb12d6.0306111021.1fba1ecb@posting.google.com>

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 Received on Wed Jun 11 2003 - 13:21:20 CDT