Re: exp/imp and defragmentation on busy database

Brian,
If I have not misunderstood your question, the answer is use the CONSISTENT=Y option on export.
Regards
Venkat

bdg_at_hotmail.com wrote in message <6dht77$sb$1_at_nnrp1.dejanews.com>...
>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
Received on Tue Mar 03 1998 - 00:00:00 CST