Re: comparing remote datadases

From: Knut Stolze <stolze_at_de.ibm.com>
Date: Mon, 20 Feb 2006 08:25:56 +0100
Message-ID: <dtbqu4$fgi$1@lc03.rz.uni-jena.de>

sreenadh wrote:

> I have already gone through Oracle Advanced replication, and it says it
> will not replicate LONG data types. And unfortunately our database
> contains many LONG types.
>
> Oracle replication FAQ suggest LOB instead of LONG. Is it possible to
> use LOB insted of LONG without having much change in application code.

I don't know if Oracle supports the casting of LONG to LOB. If it does, you might be able to use a view and replicate the view.

-- 
Knut Stolze
DB2 Information Integration Development
IBM Germany

Received on Mon Feb 20 2006 - 01:25:56 CST