Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Long and Replication

Re: Long and Replication

From: Andrew Simkovsky <asimkovsky_at_msn.com>
Date: Tue, 8 May 2001 11:17:40 -0400
Message-ID: <ebcgOaD2AHA.291@cpmsnbbsa07>

LONG and LONG RAW datatypes cannot be Replicated. You can however use a trigger to put a copy of the data into a different table using multiple VARCHAR2(4000) columns and that can be replicated.

Andrew Simkovsky
OCP DBA
Pipeline Sysop
www.revealnet.com

Frank Bluemel wrote in message <9d9a0l$pqh$05$1_at_news.t-online.com>...
>i don't now the replication of long columns works. but on a 7.3 database we
>have create a trigger on the table what writes the key fields to a help
>table. in the replication we have create a job was it writes the data to
 the
>remote database.
>
>frank
>
>"Jack" <No_at_Mail.Please> schrieb im Newsbeitrag
>news:SgUJ6.24015$662.109234_at_news1-hme0...
>> Hi
>> I have a table containing a "long" column to store my unlimited "text"
>> messages
>> I'd also like to replicate this table.
>> Is there any way of doing this in Oracle 8i?
>>
>> Thanks
>>
>>
>
>
Received on Tue May 08 2001 - 10:17:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US