Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Table-level replication
Frank van Bortel wrote:
> DA Morgan schreef:
>
>> Materialized view (older method) and Streams (newer 9i and 10g) and >> intended for data replication.
I don't think so. A materialized view, on its own, will replicate data but it is not asynchronous and the OP indicated the connection, at times, may be down. Or at least that's my recollection and I'm sticking with it. ;-)
>> I would suggest you ignore Materialized Views if, as you previously >> stated, the connection may be down. Streams is asynchronous and can >> play catch-up. Materialized views are a maintenance nightmare.
My point. And AR is not in the same galaxy, maintenance-wise as Streams.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Feb 16 2007 - 16:02:51 CST