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.org