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

From: <lempert_at_my-deja.com>
Date: 2000/03/19
Message-ID: <8b2ck7$bjr$1@nnrp1.deja.com>#1/1

In article <iXdA4.27681$Hq3.578830_at_news2.rdc1.on.home.com>, "Paul Q" <paulq_at_home.com> wrote:
> spool filename;
> select .... blah blah blah
> spool off;
>
> "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.

Hi Use the previous reply (spool ...) with the addition of fixed length fields (by substr or column length) or have the fields with comma delimiter. It'll easier for the DB2 loader to understans which field in it's place.

> >
> > Regards
> > Antony
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Mar 19 2000 - 00:00:00 CST