How to unload data

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

Julia Sats wrote:[color=blue]
> 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.[/color]

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

Julia Sats wrote:
[color=blue]
>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
>
>
>[/color]
spool

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

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" <julia.sats@sympatico.ca> wrote in message news:<Pqw5b.8890$Kj.919894@news20.bellglobal.com>. ..[color=blue]
> 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[/color]

jsun@staffordbc.gov.uk (paul sun) wrote:
[color=blue]
>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" <julia.sats@sympatico.ca> wrote in message news:<Pqw5b.8890$Kj.919894@news20.bellglobal.com>. ..[color=green]
>> 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[/color][/color]

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\datatable.csv"
set colsep ","
select * from mytable;
spool off

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

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