Ed prochak wrote:
>
> "Amy Schuele" <aschuele_at_ncsa.uiuc.edu> wrote in message news:<PS1N8.12865$U7.148549_at_vixen.cso.uiuc.edu>...
> > Hello,
> >
> > We need to copy some of our data from an Oracle 8i database to
> > our Sybase ASE database.
> >
> > I've looked at the Oracle Export utility, but can't find a way for
> > us to parse the binary that it is saved into.
> >
> > We can write a perl script to get the data, save it in Perl to a data
> > structure
> > and insert it into our Sybase database, but that will be very slow.
> >
> > I'd like to find some way to dump the data from Oracle so we can use
> > bcp to load it into Sybase. Do any of you know what Oracle tool will
> > allow me to do this?
> >
> > Thanks!
> > Amy
> > aschuele_at_ncsa.uiuc.edu
>
> Assuming you use the perl DBI, you can access ORALCE pretty much the
> same way you do SYBASE. (open a connection to ORACLE and one to
> SYBASE, query the data from ORACLE, insert the data in SYBASE, close
> connections and exit.)
>
> out of ORACLE into SYBASE
> Nothing but PERL
>
> HTH
> Ed
Or...you can dump the data from Oracle (via sqlplus, or perl, or
whatever) into a file and use bcp to get it into sybase.
--
Ron Reidy
Oracle DBA
Received on Wed Jun 12 2002 - 08:10:56 CDT
