Export table to text file (for Oracle dummy)

Top tools to do this:

FAst extraCT from Innovative Routines International (IRI), Inc. and CoSORT(cosort.com):
http://www.cosort.com/public/solutions/fact/fact.htm
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/public/solutions/product_info_request_form.htm

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/DataSheets/uni_fast_unload_r4.2_for_oracle.pdf)
Download free trial (part of Unicenter DBA Trial - registration need):
http://www3.ca.com/Solutions/Collateral.asp?CID=33557

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/dweb/index.php?id=28

------------------------
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.datatransformations.com/downloadframeset.htm

------------------------
Toad for Oracle (more info: http://www.quest.com/documents/list.aspx?searchoff=true&prod=1&contenttypeid=20)
Download trial (registration need):
http://www.quest.com/toad/software_downloads.asp

------------------------
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/download.php

------------------------
Please consult another tool LIST: http://www.db-review.com/list/0_7_1.htm for links to:
DTM Migration Kit-Powerful yet simple data migration tool. All popular database types supported.
Power DataManager-High-performance tool for processing and administering different databases
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/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:459020243348

and if you have installed Oracle Enterprise Manager you can unload your datas too...(right click on you table)...

Good luck!