How to dump table to ASCII text CSV format?
This is a discussion on How to dump table to ASCII text CSV format? within the Oracle Database forums, part of the Database Server Software category; --> Are there tools available to export a table from Oracle to a CSV file? Either an Oracle tool, or ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-24-2008, 09:33 AM
| |||
| |||
 Re: How to dump table to ASCII text CSV format? You can use sqlplus and spool to a file. Comes free with Oracle. OR Use MS Access and link to the Oracle table over ODBC (Probably the best option) OR Toad from Quest Software. I believe there is freeware version of this. OR Plsql developer from http://www.allroundautomations.com/plsqldev.html. 30 day trial Regards /Rauf      |
|
02-24-2008, 09:33 AM
| |||
| |||
| Re: How to dump table to ASCII text CSV format? On 8 Dec 2004 07:52:23 -0800, lmcphee69@hotmail.com wrote: >Are there tools available to export a table from Oracle to a CSV file? >Either an Oracle tool, or free 3rd party is OK. > >Les M Thomas Kyte has an utiltity called Sql*unloader on his website,. http://asktom.oracle.com -- Sybrand Bakker, Senior Oracle DBA |
|
02-24-2008, 09:39 AM
| ||||
| ||||
| Re: How to dump table to ASCII text CSV format? TOAD also has this feature by right clicking on the DATA (output of the query) use "SAVE AS" not the "EXPORT TO FLAT FILE" George Sybrand Bakker wrote: > On 8 Dec 2004 07:52:23 -0800, lmcphee69@hotmail.com wrote: > > >Are there tools available to export a table from Oracle to a CSV file? > >Either an Oracle tool, or free 3rd party is OK. > > > >Les M > > Thomas Kyte has an utiltity called Sql*unloader on his website,. > http://asktom.oracle.com > > > -- > Sybrand Bakker, Senior Oracle DBA |
Linear Mode
