You might want to take a look at Oracle Streams ...
"Pete's" <empete2000_at_yahoo.com> wrote in message
news:6724a51f.0411120652.3f7105b7_at_posting.google.com...
> Vital info:
>
> Both servers are at AIX 5.2 ml 03, Oracle 9.2.0.4 EE. Database, PROD1
> on SERVER1, QA_TEST1 on SERVER2.
>
> Questions:
> Has anyone ever setup a logical standby for only a couple tables into
> another database? I read through documentation on Logical Standby's
> and how to set them up, is it required to have a complete copy of the
> primary db to set it up on just a couple tables? Or is it just a
> matter of setting up the all the SQL APPLY & LOG Transport services
> correctly for it to work?
>
> TIA
> Pete's
Received on Fri Nov 12 2004 - 11:27:57 CST
