A quick and dirty hack to the existing PL/SQL code
which typically adds good performance improvement is
to fetch from your cursor in bulk collect (say 200-500
records at a time).
Otherwise its Perl/C/etc/etc time.
hth
connor
--- Tim Gorman [EMAIL PROTECTED] wrote: Options
#1 (Perl) and #2
I also have one in Perl that I use to dump an entire schema
to flat files, generating sqlldr parameter and control files
as is goes.
sqlunldr.pl is part of the PDBA toolkit:
http://www.oreilly.com/catalog/oracleperl - click on 'Toolkit'
Jared
On Sat, 2004-01-10 at 19:39, Rachel Carmichael
Is there a place that we can see the code without installing the PDBA
toolkit? I don't need to dump any table or schema, I just need to dump a
selected query result (many many rows) into a text file.
Do you just use perl's print to write data?
Guang
On Sun, 11 Jan 2004, Jared Still wrote:
I
Hi:
I have a program (running on oracle 8173 server) that writes 48 Millions
lines of data into various text files . The selected data is from various
tables and I have the query pretty much optimized. Now I am trying to find
the fastest way to dump the selected data into a text file on the same
Jared has a utility to dump tables to flat files
http://www.cybcon.com/~jkstill/util/
on the lefthand menu, under Utilities click on Dump Tables to Flat
Files
--- Guang Mei [EMAIL PROTECTED] wrote:
Hi:
I have a program (running on oracle 8173 server) that writes 48
Millions
lines
Options #1 (Perl) and #2 (PRO*C) would be fastest and easiest. The PRO*C
demo programs provide a decent start, for option #2. Option #3 (OCI) would
be not faster than PRO*C and, due to the increased complexity of OCI, a more
problematic approach.
SQL*Plus is the easiest method to implement by
