Re: Help Required: How can I export my Oracle data into a flat file

Hi,

Try to use Oraxcel LITE to get it into Excel initially. Then use Excel to save it into a flat file or csv. Oraxcel LITE is free and implements the feature you require. You can get Oraxcel LITE from

http://www.oraxcel.com

Regards, Gerrit-Jan Linker

TurkBear <johng_at_mm.com> wrote in message news:38d15989.12705639_at_204.181.81.99...
>
> The easier way is to use a 3rd party tool to export the data :
> I use Crystal Reports 8 from seagate and it exports in comma delimited
 format (
> along with many, many others) which I can use in many other apps (or as a
 data
> file for SqlLoader to use)
> many other report writers will allow exports to a dilimited format, as
 will
> Access, Excel etc...
>
>
> "Abey Joseph" <abeyj_at_netzero.net> wrote:
>
> >Antony,
> > I am not an expert on this matter... I don't know if there
 is a
> >better/more efficient way to accomplish the same.
> >
> >SPOOL filename
> >SELECT * FROM table;
> >
> >The above statement would write all columns in all records to filename.
 The
> >fields will be fixed length. If you want delimited fields you would have
 to
> >write the SQL statement and concatenate the delimiter and columns. I
 hope
> >there's an easier way...
> >
> >Abey Joseph.
> >
> >"PSINet News Service" <Antony.Amalraj_at_tpg.com> wrote in message
> >news:7E8A4.416$iB5.781_at_client...
> >> Hello All,
> >>
> >> I am new to oracle, I want to export the table data(From
 oracle)
> >> alone into flat file.From the flat file I want to import the data into
> >> another database(db2) table.
> >>
> >> Can any one help me.
> >>
> >> Regards
> >> Antony
> >>
> >>
> >>
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Fri Mar 31 2000 - 00:00:00 CST