Data from Oracle to Sybase

From: Amy Schuele <aschuele_at_ncsa.uiuc.edu>
Date: Mon, 10 Jun 2002 08:36:10 -0500
Message-ID: <PS1N8.12865$U7.148549@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 Received on Mon Jun 10 2002 - 08:36:10 CDT