RE: replication with Indexes

From: <Stephen.Lee_at_DTAG.Com>
Date: Wed, 26 May 2004 16:20:30 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B0790940F@bu-dtagpo1.tracs.com>

> -----Original Message-----
> The db2(snapshot site) wILL be for failover site.therfore I
> want to setup updatable replication

Sorry. I've not worked with updateable snapshots. If you are like me and prefer the K.I.S.S** method whenever possible (mainly because if I make it complicated, three months from now, I'll forget what I did), at failover time you can drop the snapshots that were created on the prebuilt tables. The data will remain, and now you can slam it around all you want. In this case, you might want to leave the constraints in place in the secondary database when you set the thing up. With this approach, nobody will be able to update the secondary database until you drop the snapshots. So that's something to consider.

**(Keep It Simple Stupid)

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 26 2004 - 16:17:33 CDT