> -----Original Message----- > because when we run create snapshot command it will failed > with error object already exist.? I don't know your Oracle version, but if you can: create snapshot xyz ON PREBUILT TABLE etc. ... Then your Oracle version is OK. There is more than one way to create the tables in the secondary database. I usually create the empty tables, then for each table: exec dbms_snapshot.refresh('TABLE_NAME','C') set up the refresh group and refresh schedule (usually every five minutes for me). This certainly isn't the only way to do it. I have never set up a failover site like this. I just do it this way because we have so many frequent changes, that I do not want to completely lose a snapshot table whenever I must temporarily drop a snapshot in order to make some change. Sometimes in our test environment, we might want to split a replication pair to run independently for a while. Then put replication back in later. ---------------------------------------------------------------- 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 -----------------------------------------------------------------