From: "Daniel A. Morgan" <dmorgan@exesolutions.com>
Subject: Re: export to ascii file
Date: 1997/04/02
Message-ID: <334330D4.513C@exesolutions.com>#1/1
References: <333DC0E2.1FAB@lingocd.com>
To: Raul Sanchez <rsanchez@lingocd.com>
Organization: EXE Solutions, Inc.
Reply-To: dmorgan@exesolutions.com
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,comp.databases



> I would like to know how or where I might find information on how
> to export a table to an ascii file in ORACLE (for example, in SYBASE
> I would use the following:
> 
> bcp databaseName..tableName out dataFile -c .....

A simple way, from SQL*Plus would be as follows:

spool c:\temp\textfile.txt
select * from mytable;
spool off

This will create an ASCII text file.

Daniel A. Morgan