replication with Indexes 2004-05-26 - By Stephen.Lee@(protected)
> -- --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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
