Re: exp/imp and defragmentation on busy database

From: PD Miller <news_watcher_at_caribdata.no_spam.demon.co.uk>
Date: 1998/03/08
Message-ID: <news_watcher-0803981517070001@caribdata.demon.co.uk>#1/1

In article <6dht77$sb$1_at_nnrp1.dejanews.com>, bdg_at_hotmail.com wrote:

> I've read quite a bit of documentation and discussion on using exp/imp
> to change the initial extent of a table. But I've found no mention
> of what pre-exp or post-imp steps are necessary to "lock" the table
> during the defragmentation process. Seems that without such a step,
> there could be loss of data. For example, changes made to the table
> between the export and the dropping of the table.
>
> Any pointers appreciated,
> Brian Gastineau
> bgastine_at_giveblood.org
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Between the export and the drop you cannot be certain that no DMLs are executed. Either bring the database up in RESTRICT mode or revoke update/insert/delete grants during the cycle.

If this is a high availability system, reconsider whether de-fragmentation is really needed right now.

Hope this helps

PD Miller
Carib Data Limited Received on Sun Mar 08 1998 - 00:00:00 CST