I have attached some generic scripts for creating the snapshots and refresh procedures. The only item missing is the database link.
Basic outline: 1. create database link 2. create snapshot logs on primary 3. create snapshots on copy 4. run a full refresh 5. run a fast refresh 6. setup jobs with force refresh Regards, -Daniel -- Daniel Harron Database Management IPsoft, Inc. [EMAIL PROTECTED] http://www.ip-soft.net/ Phone: 888.IPSOFT8 Fax: 801.681.7664
snapshot_create.sql
Description: Binary data
snapshot_log_create.sql
Description: Binary data
snapshot_refresh_all_atomic.sql
Description: Binary data