Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: bulk dumping?
hi
there is no select into any files buyt u can create a pl/sql program in
which select the data in a cursor and place the data in a text file
using TEXT_IO /UTL_FILE package.hope you can get it.
Bye
sarvan (wannab dba)
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.
Received on Thu Jun 15 2006 - 11:50:56 CDT