Have you not tried for ODBC ?
Main Topics
Browse All TopicsI have seen several posts describing how to export Oracle tables to flat files using scripts, programs and various other "techy" approaches. I am not an Oracle DBA, but need to export Oracle tables to flat files with pipe column delimeters, what is the easiest way, preferably with a GUI tool to do this?
Thanks!
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Top tools to do this:
FAst extraCT from Innovative Routines International (IRI), Inc. and CoSORT(cosort.com):
http://www.cosort.com/publ
FAst extraCT (FACT) is a high-performance data delivery tool for Oracle DBAs requiring faster reorgs and queries, and for high-volume data warehouse extract, transform, and load architects.
Download free trial (registration need):
http://www.cosort.com/publ
Fast Unload
Unicenter® Fast Unload® - Unicenter Fast Unload for Oracle is a high-performance data export utility that provides a fast, reliable and efficient way to extract database information, outputting your data in a fraction of the time to which you’re accustomed. (More info at: http://www3.ca.com/Files/D
Download free trial (part of Unicenter DBA Trial - registration need):
http://www3.ca.com/Solutio
Cheap solutions:
------------------------
The WisdomForce™ FastReader™ provides Database Administrators, Data Warehouse Architects, Developers and QA with the ability to make a quick snapshot of data from a Database. FastReader can unload and extract Oracle tables of any size (terabytes of data) into portable flat text files in a fraction of the time and with no system overhead. The user is able to easily configure the output format which can be csv, xml, etc. The user is able to perform fast and selective unload of data from Oracle which effectively utilizes the multi-processor environment. At the same time, FastReader automatically prepares input for high-speed loaders such as Oracle SQL*Loader, bcp, etc. WisdomForce™ FastReader™ works on major databases, including Oracle, DB2, MSSQL, MySQL, Sybase.
FastReader supports most operating systems and platforms: Sun Solaris, HPUX, AIX, Tru64, Windows, Linux/386, IA64.
-Download FastReader Trial (registration need):
http://www.wisdomforce.com
------------------------
Granger Unload is a utility allowing you to load data from DBMS tables, at the same time the Oracle SQL*Loader Control statement for later reloads is created. There is a moderate set of settings and the multiple table selection feature. The program performs nothing beyond the mentioned. The interface is very simple, clear and convenient. Loading is performed quickly and without any troubles. Unfortunately, there is no documentation in the distributive at all, which spoils a generally good impression.
Download trial:
http://www.datatransformat
------------------------
Toad for Oracle (more info: http://www.quest.com/docum
Download trial (registration need):
http://www.quest.com/toad/
------------------------
Hora unload/load facility: added as part of the upgrade from Version 5 to Version 6, the Import and Export Wizards permit users to import from such formats as Microsoft Excel, DBF, XML, and text; and to export to these formats and to Microsoft Word, PDF, and HTML—just to name a few examples. In other words, there is no more need to create comma-delimited files as an intermediate step when moving data into or out of the database in order to interface with end users.
Download trial:
http://www.keeptool.com/en
------------------------
Please consult another tool LIST: http://www.db-review.com/l
DTM Migration Kit-Powerful yet simple data migration tool. All popular database types supported.
Power DataManager-High-performan
DTM SQL editor-Set of powerful database management tools: ODBC support, schema viewer, builder
DTM Object Inspector-DTM Object Inspector is a comprehensive toolkit for database schema management
SQLWays-SQLWays is a database migration tool. It transfers database structures and data.
DBScripter for Oracle-Create sql scripts out of any oracle database's objects, data and source code
DBScripter-ODBC database utility that creates a script of a database
DBX Commander-Tool for manipulation of data, contained within various types of databases
Advanced Query Tool-Simple and fast database query utility, designed for the DB developer and DBA
ADO Explorer-ADO Explorer is a powerful SQL database tool using ADO
DBQwikEdit Pro-DBQwikEdit is a program for accessing and managing data in almost any database
DBExplorer-Compares any two databases and report the structural and data differences
DB Tools for Oracle-Integrated set of "must have" tools for Oracle databases.
and You must know AskTom Pro/C solution:
http://asktom.oracle.com/p
and if you have installed Oracle Enterprise Manager you can unload your datas too...(right click on you table)...
Good luck!
Business Accounts
Answer for Membership
by: tomerbarPosted on 2005-08-04 at 15:46:09ID: 14603535
Download Pl/Sql developer and select the data you would like to export,
by pressing the right mouse button of the mouse on the corner of the results you can copy the data to excel, it does the job perfectly.
Hope it works.
Tomer.