How to unload data

[Julia Sats]

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

[Ana C. Dent]

Julia Sats wrote:

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

What wrong with SQL*Plus or Read The Fine Archives
where this question has been asked & answer NUMERSOUS
times recently.

[Daniel Morgan]

Julia Sats wrote:

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

spool

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.wash ington.edu
(replace 'x' with a 'u' to reply)

[paul sun]

if you have MS Access, it will be quite simple. go to access----
select open, select ODBC as source, put the table(s) you want to
export into the access.---choose export option from access---then
simply following the wizard to finish the rest.

good luck!
"Julia Sats" <ju********@sym patico.ca> wrote in message news:<Pq******* ***********@new s20.bellglobal. com>...

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

[Turkbear]

js**@staffordbc .gov.uk (paul sun) wrote:

if you have MS Access, it will be quite simple. go to access----
select open, select ODBC as source, put the table(s) you want to
export into the access.---choose export option from access---then
simply following the wizard to finish the rest.

good luck!
"Julia Sats" <ju********@sym patico.ca> wrote in message news:<Pq******* ***********@new s20.bellglobal. com>...

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

Or, to avoid reading the data twice, look into the SPOOL command and create your file from SqlPlus:

Example follows ( not to be actually used as it is not precise or the best way and, of course yours will vary)
set heading off
set lines 1000
set pagesize 0
set termout off
set feedback off
spool "c:\mydir\datat able.csv"
set colsep ","
select * from mytable;
spool off

[dbaman]

I am using Fastreader from wisdomforce to unload data into txt comma delimited format. fastreader is fast and also creates loaders. can be found here: wisdomforce.com

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks

[oracle12345]

We also using Fastreader for unload data from our large Oracle tables into txt file. We use csv format

fastreader description is at wisdomforce : www.wisdomforce.com

The nice thing about fastreader it has fast compression on the fly (how they called). When data is extracted it is automatically compressed using their compressor feature. Thus output is relatively small and can be quickly transfered to destination server were it unzipped

Hi,

Oracle contains SQL*Loader for loading data to Oracle.
Does exis any tool for quickly unload (extract data) from Oracle's table to
TXT file, preferable to comma separete format.

I can use for it UTL_FILE but I need to work with every record of the table.

Thanks