Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> Fastest method to write output to a text file in Oracle 8

Fastest method to write output to a text file in Oracle 8

From: John Leslie <johnleslie_at_madasafish.com>
Date: 25 Apr 2003 07:21:17 -0700
Message-ID: <4412dd31.0304250621.70d3b00d@posting.google.com>

I need to write a large number of records(500000) to a text file from PL/SQL in Oracle 8i.

Currently I am using utl_file, but it is slow.

Is there any quicker way? Received on Fri Apr 25 2003 - 09:21:17 CDT

This message: [ Message body ]
Next message: news.verizon.net: "Re: exit in sql script"
Previous message: Jim Kennedy: "Re: Reseting a sequence number to value less than current last_number"
Next in thread: Rahul: "Re: Fastest method to write output to a text file in Oracle 8"
Reply: Rahul: "Re: Fastest method to write output to a text file in Oracle 8"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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