Re: How to export table data to a text file?

From: Sweet Pete <pgadah_at_magicnet.net>
Date: Fri, 21 Sep 2001 08:18:20 GMT
Message-ID: <3baaf71b.9487805@news.magicnet.net>

Zhou,

Unfortunately you will not be able to do this via export. If you export a table, from an Oracle database, the export file is written in a proprietary format that only import can read. My recommendation to you is to use a tool, like SQL*PLUS, and enable spooling so that the output gets spooled to a text file (plain text and not proprietary).

Regards,
Peter

On Thu, 20 Sep 2001 22:30:18 +0900, "Huiqun Zhou" <zhou_at_ra2.so-net.ne.jp> wrote:

>Hi,
>
>I'm a newbie for Oracle. Could anyone let me know how to export
>data of a table into a text file? Is exp the right tool?
>
>Thanks,
>
>zhou
>
Received on Fri Sep 21 2001 - 03:18:20 CDT