From: bdg@hotmail.com
Subject: exp/imp and defragmentation on busy database
Date: 1998/03/03
Message-ID: <6dht77$sb$1@nnrp1.dejanews.com>#1/1
X-Originating-IP-Addr: 208.196.149.246
X-Http-User-Agent: Mozilla/4.01 [en] (Win95; I)
Organization: Deja News - The Leader in Internet Discussion
X-Article-Creation-Date: Tue Mar 03 21:38:17 1998 GMT
Newsgroups: comp.databases.oracle.server



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@giveblood.org

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading