Re: snapshot master table export!

From: Ronald <devnull_at_ronr.nl>
Date: 14 Nov 2001 02:53:53 -0800
Message-ID: <67ce88e7.0111140253.5af921cd@posting.google.com>

jonathan_at_ms35.url.com.tw (Trister ) wrote in message news:<9sq246$3ju$1_at_news.seed.net.tw>...
> i have a table A which has a snapshot B in remote site.
>
> when i export ,then truncate,drop,import table A in master sit,
>
> then snapshot B refresh failure in romote site.
>
> If I want to reorganize table A, how should I do?

How about DBMS_SNAPSHOT.BEGIN_TABLE_REORGANIZATION() before you begin the reorganization and DBMS_SNAPSHOT.END_TABLE_REORGANIZATION() when you are ready ?
Maybe it is smarter not to drop the table; you already truncated it.

Ronald.

---

http://ronr.nl/unix-dba
Ben je een ervaren dba en wil je dit wel eens ergens anders laten zien, mail me dan. Received on Wed Nov 14 2001 - 04:53:53 CST