Re: bulk dumping?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 15 Jun 2006 06:31:41 +0200
Message-ID: <6un1925cs2cqvgsnniamk9go2e22lv5of1@4ax.com>

On 14 Jun 2006 17:36:31 -0700, newtan_at_gmail.com wrote:

>Is there a way in oracle 9i to bulk-dump data into a flat file? some
>sort of "SELECT INTO OUTFILE '/path/to/datafile'"? i tried to search
>for the syntax on oracle site and the net for a couple of hours and
>couldn't seem to find anything except for a recommended usage of
>sqlplus + spool....thanks much.

go to http://asktom.oracle.com search for 'SQL unloader'

--
Sybrand Bakker, Senior Oracle DBA

Received on Wed Jun 14 2006 - 23:31:41 CDT