In 8.1.5 you can replicate LOB's but not longs. Straight from
the 8.1.5
replication manual:
"Multimaster replication supports the replication of tables with columns
that use the following datatypes: NUMBER, DATE, VARCHAR2, CHAR,
NVARCHAR2, NCHAR, RAW, ROWID.
Oracle also supports the replication of tables with columns that use
the
following large object types: binary LOBs (BLOBs), character LOBs
(CLOBs), and national character LOBs (NCLOBs). The deferred and
synchronous remote procedure call mechanism used for multiple master
replication propagates only the piece-wise changes to the supported
LOB
datatypes when piece-wise updates and appends are applied to these
LOB
columns.
Note:
Oracle8i
does not support replication of LOB datatypes in
replication environments where some sites are running Oracle7 release
7.3.
Oracle does not support the replication of columns that use the LONG
and
LONG RAW datatypes. Oracle simply omits columns containing these
datatypes from replicated tables.
Oracle also does not support user-defined object types and external
or
file-based LOBs (BFILEs). Attempts to configure tables containing
columns of these datatypes as masters will return an error message."
HTH.
Pete
[email protected] wrote:
Question:
> Is it possible to replicate longs, lobs, clobs, and the like with
> standard ORACLE 8.1.5 replication, or do these not replication with
> tons of headaches? I'm talking store and forward, not snapshot
> replication.
>
> thanks,
>
> dave
>