Re: extracting data from Oracle6 db

From: John F. Keaveney <johnkeaveney_at_targusinfo.com>
Date: Thu, 21 Oct 1999 11:14:18 -0700
Message-ID: <7uqa9p$sov$2@ffx2nh3.news.uu.net>

It depends on your platform...

I wrote a simple application which generates comma, seperated value files from any
Oracle table. You could then import this into sybase I suppose.

One possible solution (not sure if this would work) is to use MS Access as a go between. Create a ODBC link to both dbs and then populate the sybase tables by
doing selects on the oracle tables.

John
<tengu_zori_at_my-deja.com> wrote in message news:7und2j$77n$1_at_nnrp1.deja.com...
> Hello,
>
> I am trying to extract data from an Oracle 6 database
> and load it into a Sybase database.
> However I have no knowledge of Oracle and when attempting
> to use the export command, non of the data is copied out.
>
> Is there a means of formatting this extracted data into a
> format understood by Sybase?
>
> Many of the database tables contain white spaces ...which means that
> a select * from tablename is not suitable.
>
> Thanks for your help!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 21 1999 - 13:14:18 CDT