Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Download data from oracle tables to flat file
That is one of the fastest (code development that is) ways, but you should also:
set termout off
set heading off
set pagesize 50000
set newpage 1
____________________Reply Separator____________________Subject: Download data from oracle tables to flat file Author: Balasubramanian M <sbala_at_hclinsys.com> Date: 5/4/00 10:38 AM
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
-- Author: Balasubramanian M INET: sbala_at_hclinsys.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 04 2000 - 15:39:15 CDT
![]() |
![]() |