Re: Download data from oracle tables to flat file

From: Vidya Kalyanaraman <kvidya13_at_hotmail.com>
Date: Thu, 04 May 2000 09:36:05 EDT
Message-Id: <10487.104924@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_25113282_7deb37d6$6c055e88
Content-Type: text/plain; format=flowed

Hi Bala,

  Pls have a look at the attached file(Owner: Jared Still).   It is a simple sql file and easy to use.

Thanks
Vidya

From: Balasubramanian M <sbala_at_hclinsys.com> To: oracledba_at_quickdoc.co.uk
CC: ORACLE-L_at_fatcity.com
Subject: Download data from oracle tables to flat file Date: Thu, 4 May 2000 10:13:00 +0530 (IST)

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

---

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

------=_NextPart_000_25113282_7deb37d6$6c055e88

Content-Type: text/plain; name="crt_loadfile.txt"
Content-Transfer-Encoding: 8bit
Content-Disposition: attachment; filename="crt_loadfile.txt"

<binary content removed -- do not send binaries to the list> Received on Thu May 04 2000 - 08:36:05 CDT