Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting ASCII Text file
Hi,
Try a tool at http://www.ispirer.com/chyfo.html
It CAREFULLY converts data to a CSV, TAB, fixed length. Creates CREATE TABLE scripts for Oracle, control file for SQL Loader.
It also supports other databases so it will be helpful if you are performing migration tasks.
Moving of LOBs are supported.
-- Best regards, Dmitry In article <lHye6.893$Zp3.90475_at_e3500-chi1.usenetserver.com>, "Rob Diaz" <rdiaz_at_ebudgets.com> wrote:Received on Tue Feb 06 2001 - 13:33:14 CST
> How does one go about exporting an ASCII text file representation of
a table
> from Oracle 8? (specifically, 8.0.6). We need this file to be able
to
> import again (eventually) using sql*loader, as well as excel and other
> tools.
>
> Thanks in advance!
> Rob
>
>
Sent via Deja.com http://www.deja.com/