Re: LONG RAW Manipulation

From: Tommy <tcusan_at_yahoo.com>
Date: Fri, 16 Oct 1998 16:58:42 -0700
Message-ID: <3627EBC2.7BA133A7@yahoo.com>

Barry,
LONG datatypes are not replicated due to the limitations with PL/SQL. The LONG data type columns cannot be replicated using row-level replication.
If a table has a LONG column, Oracle will not error out while doing a CREATE_MASTER_REPOBJECT or GENERATE_REPLICATION_SUPPORT. The modifications to
that column is not propagated.
Also, Oracle8 does not support user-defined object types and file based LOB's
(BFILEs).

Thomas Barry wrote:

> Hi-
>
> I've got an application where I need to replicate a
> table containing a LONG RAW column from one instance
> to another (Oracle 7.3). I know that a snapshot won't
> do it- it'll replicate the table but ignore the data.
> Is the only option to write an OCI program and use
> the piecewise operations on the LONG RAW data, or is
> there another method that I'm unaware of?
>
> Thanks,
>
> Thomas Barry
> TwoCoast Consulting
Received on Fri Oct 16 1998 - 18:58:42 CDT