Re: 9iR2 Logical Standby

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 12 Nov 2004 19:37:32 GMT
Message-ID: <419510f2.335479283@localhost>

Look into snapshots/materialized views.

On 12 Nov 2004 06:52:04 -0800, empete2000_at_yahoo.com (Pete's) wrote:

>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

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Nov 12 2004 - 13:37:32 CST