Re: exp/imp and defragmentation on busy database

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/03/04
Message-ID: <34FD2B31.32672F2A@ubs.com>#1/1

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

To have a consistent export mount the database in restricted mode (or use the consistent=y option when resticted mode not pos.). rgds
eugen Received on Wed Mar 04 1998 - 00:00:00 CST