Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 9i Advanced Replication
frank.van.bortel_at_gmail.com wrote:
> Streams would be nice (you can/should be able to set up replication for
> a schema, as you require), but it's pretty bug-ridden in 9iRel2. And
> some are nasty.
> Advanced replication (using materialized views) is old, proven
> technology, but more cimbersome to set up.
>
> Depending on why you want to replicate, I'd look into another
> possibility: that of transportable tablespaces.
>
> When your migration to 10g is eminent, I'd go for Streams.
>
> My 2 c,
> Frank van Bortel
>
Hm - after I crashed Streams in an attempt to replicate
half a million rows, I'm not so sure.
But this was HP-UX/9.2.0.4
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Mon Mar 06 2006 - 13:50:17 CST