partitioned table maintenance and snapshot refresh

From: zhu chao <chao_ping_at_vip.163.com>
Date: Mon, 22 Mar 2004 15:06:40 +0800
Message-ID: <000701c40fdc$4d84ff40$2d42813d@chaos>

hi, list friends:

    I have a primary database using partitioned table and a snapshot site get the data from primary.

    Whenever I add/drop partition on the partitioned table, the snapshot log on this table get invalid, I can no longer do fast refresh on snapshot site. I have to drop the snapshot log and recreate it,and do a full refresh on the snapshot site.

    As the table as several million records, it is something troublesome. Is there any work around , without full refresh the snapshot table?

    Primary database platform is 8174 on solaris, and snapshot site running 9204 on linux.

Thanks
Zhu Chao

---

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 Mon Mar 22 2004 - 01:06:36 CST