Re: exporting from ORACLE

From: RYoung <ryoung_at_summer.dbsol.com>
Date: 1997/03/31
Message-ID: <01bc3df6$c2c26460$fb428ad0@pc060.groupZ.net>#1/1

Oracle does not have a built in for exporting its data to an ASCII file per se. You can use the exp utility to get the table definition, etc in ASCII. But it will not be in a format that can be re-read by another app. To export the data in ASCII such that you can save it in a 'standardized' format such as comma delimited, etc I would suggest using a product like MS Access or Lotus Approach, linking to the remote Oracle table via ODBC, and then exporting from the Windows app.
To get it from Oracle directly, you will have to write a SQLPlus or PL/SQL routine to do the job.

Raul Sanchez <rsanchez_at_lingocd.com> wrote in article <333DBF14.7FEB_at_lingocd.com>...
> Hi,
>
> 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:
>
Received on Mon Mar 31 1997 - 00:00:00 CST