Re: What are you using as your master-slave replication option (w/blobs)

From: <array7_at_inbox.com>
Date: Fri, 30 Nov 2007 18:14:29 -0800 (PST)
Message-ID: <955c38ab-11cb-46ca-81f6-989a5dacc2b6@s36g2000prg.googlegroups.com>

On Nov 7, 1:45 am, arr..._at_inbox.com wrote:
> On Nov 6, 12:38 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
>
> > We have had good luck with Streams for *LOB types, and also use
> > advanced replication for unsupported datatypes such as XMLTYPE.
>
> > HTH,
>
> > Steve
>
> My understanding is that BLOBs are translated either into varchar or
> raw datatype for the LCRs.
> How were you handling BLOBs bigger than 2K in size (or 32K for
> varchars)?

Oracle advised that starting certain release blobs are now broken into several LCRs, thus transmitting the entire blob, despite varchar2 & raw types limitation.

So ultimately, I made Streams work. Received on Fri Nov 30 2007 - 20:14:29 CST