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

Home -> Community -> Mailing Lists -> Oracle-L -> Download data from oracle tables to flat file

Download data from oracle tables to flat file

From: Balasubramanian M <sbala_at_hclinsys.com>
Date: Thu, 4 May 2000 10:13:00 +0530 (IST)
Message-Id: <10487.104950@fatcity.com>


Hi all,

Is there any way to unload the data to flat file other than using

spool on
select * from <table_name>

For very large table having thousands of rows, the above technique will be very slower.

Is there any other way i can unload the data from the tables faster ? Any kinf of help is appreciated.

Regards,

Balasubramanian .M Received on Wed May 03 2000 - 23:43:00 CDT

Original text of this message

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