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

#1

Interested in practical experience with Oracle replication, esp. when
replicating blobs in medium-sized databases.

What have you chosen, why, and how happy you are with it.

We are running 10.0.2 at this point, and looking rather into 1-master

Quote:

many slaves replication with a short, but not realtime lag.

#2

On Nov 6, 2:41 pm, arr... (AT) inbox (DOT) com wrote:

Quote:

Interested in practical experience with Oracle replication, esp. when
replicating blobs in medium-sized databases.

What have you chosen, why, and how happy you are with it.

We are running 10.0.2 at this point, and looking rather into 1-master

many slaves replication with a short, but not realtime lag.

Hi,

We have had good luck with Streams for *LOB types, and also use
advanced replication for unsupported datatypes such as XMLTYPE.

HTH,

Steve

#3

On Nov 6, 12:38 pm, Steve Howard <stevedhow... (AT) gmail (DOT) com> wrote:

Quote:

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)?

#4

On Nov 6, 12:38 pm, Steve Howard <stevedhow... (AT) gmail (DOT) com> wrote:

Quote:

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)?

#5

On Nov 7, 1:45 am, arr... (AT) inbox (DOT) com wrote:

Quote:

On Nov 6, 12:38 pm, Steve Howard <stevedhow... (AT) gmail (DOT) 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

What are you using as your master-slave replication option (w/blobs) - 11-06-2007 , 01:41 PM

Re: What are you using as your master-slave replication option (w/blobs) - 11-06-2007 , 02:38 PM

Re: What are you using as your master-slave replication option (w/blobs) - 11-06-2007 , 07:18 PM

Re: What are you using as your master-slave replication option (w/blobs) - 11-07-2007 , 03:45 AM

Re: What are you using as your master-slave replication option(w/blobs) - 11-30-2007 , 08:14 PM