> -----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 -----------------------------------------------------------------