RE: REPLICATION

From: <Stephen.Lee_at_DTAG.Com>
Date: Tue, 29 Jun 2004 14:35:12 -0500
Message-ID: <D6339830FC73944E889CC3CEADDB205B079094C4@bu-dtagpo1.tracs.com>

> -----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_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 Tue Jun 29 2004 - 14:31:58 CDT