Re: Download data from oracle tables to flat file

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Thu, 4 May 2000 14:02:34 -0400
Message-Id: <10487.104955@fatcity.com>

It's really not that slow if you do "set termout off" before the select. Also, I'd recommend putting a delimiter like TAB between columns.

--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                   
                    Balasubramani                                                                                  
                    an M                 To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    <sbala_at_hclins        cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    ys.com>              Subject:     Download data from oracle tables to flat file                
                    Ext: NA                                                                                        
                    Sent by:                                                                                       
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/04/00                                                                                       
                    02:38 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   

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 - 13:02:34 CDT