Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Streams or Logical Dataguard
shiva wrote:
> Hello,
>
> I'm debating about using either Logical dataguard or one way streams
> replication for a database which needs heavy reporting. DB size is
> about 100GB and does about 100K transactions everyday (Not many
> updates, mainly inserts/deletes and selects). I have set up dataguard
> and streams in the past and learning curve is not a problem.
>
> Which one would you pick between two and why?
>
> Thanks
If you need the entire database to a single location ... use Data Guard. If you need to specify tables, columns, schemas, rules, and are in a publish-subscribe situation use Streams.
Both technologies were written by the same people and share a common architecture.
-- 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 Sep 07 2007 - 19:44:56 CDT
![]() |
![]() |