Re: best way to export Oracle table into a text file?

AMARENDRA B NETTEM wrote:
>
> Igor wrote:
> >
> > I'm looking to easiest ( and free ) way to export Oracle table as a TEXT
> > file ( in a format 1 row/line, several K rows, each row <100 chars).
> > Any suggestions/scripts/programs etc will be appreciated
> >
> > Igor
> You can do this in couple of ways. One is spool the table to a text file
> (formatted sql report) and the other option is through MS ACCESS using
> ODBC.
> Hope this helps
> --
> AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
> ORACLE CONSULTANT
> WHITTMAN-HART CORPORATION
> CHICAGO.
What about >1000 char/row. Why don't I find a tool oposite to Loader. May be I am spoiled with visual tools or I am too afraid that I miss some characters, fiddeling with SPOOL technik.

My concern is not just academical. We have in fact a huge database, that is completely wrong, due to bad NLS_LANG setting when creating the database. When we tried to export the tables with one NLS setting and import it to another base with right NLS, the import refused to accept the file because it "clever" enough discovered that the NLS was changed. So the only chance we have is to output the tables in plain text, change the NLS and load back with the Loader.

Regards Tony.
P.S. If NLS_LANG is a buzzword to you, just forget it. Since you live in Chicago, you will probably never have to know. The problem was about, how to get the table out, so it can be loaded back with something else but import. Received on Thu Nov 21 1996 - 00:00:00 CET