Re: Exporting Oracle Database into text file

Hi ,
1. You can use Powerbuilder ( 4.0 and above) datapipeline feature to load the data from Oracle database to MS SQL server . 2. Get the values into a flat file using select ( before that set pagesixe,feedback header etc etc )

      Then do a bcp in into SQL Server .

Regards
Anbu

Regards

Steve Barthakur <sbarthakur_at_tesent.com> wrote in article <01bc938d$6d90a8c0$de7c20ce_at_sbarthakur.tesent.com>...
> You may need to shut off the page break to get a contiguous flat file for
> another load tool.
>
> -S.B.
>
>
> Alex Cheung <alexcheung_at_onramp.ca> wrote in article
> <33B91AAA.7DBF_at_onramp.ca>...
> > yoong pan wrote:
> > >
> > > Is there a way to export oracle database into a delimited text file?
> > >
> > > Also, is there a way to import oracle database into ms-SQL server?
> > >
> > > Thanks.
> > >
> > > --
> > > ---------------------------------
> > > | Eric Y. Pan (~{EKHYG?~} )
> > > | http://www.mech.utah.edu/~pan
> > Eric:
> > You can use sqlplus with spool option which will re-direct the
> > outpur to a OS physical file.
> > Good luck.
> > Alex Cheung
> >
>
Received on Sun Jul 20 1997 - 00:00:00 CDT