469,089 Members | 1,227 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,089 developers. It's quick & easy.

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
Jul 19 '05 #1
6 30986
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.

Jul 19 '05 #2
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.washington.edu
(replace 'x' with a 'u' to reply)

Jul 19 '05 #3
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********@sympatico.ca> wrote in message news:<Pq******************@news20.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

Jul 19 '05 #4
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********@sympatico.ca> wrote in message news:<Pq******************@news20.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\datatable.csv"
set colsep ","
select * from mytable;
spool off

Jul 19 '05 #5
dbaman
1
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
Sep 11 '05 #6
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
Oct 9 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by dbaman | last post: by
2 posts views Thread by shabnam via DBMonster.com | last post: by
reply views Thread by mick | last post: by
reply views Thread by JAW | last post: by
reply views Thread by Sam Durai | last post: by
4 posts views Thread by Julia Sats | last post: by
2 posts views Thread by tonik | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.