RE: REPLICATION

  • From: Stephen.Lee@xxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 29 Jun 2004 14:35:12 -0500

> -----Original Message-----
> etc) can I make READ-ONLY MODE database to READ-WRITE mode.

If you create the secondary tables first as normal tables, then create the
snapshots on prebuilt tables, you can drop the snapshots later and use the
tables normally.

HOWEVER!!!

In the event of a disaster fail-over, the data in the secondary database
will only be current as of the last replication cycle.  And if data is
modified in the secondary database, you might have a messy job of fixing
data conflicts to go back to using the primary database again.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: