Re: export, drop, import is the way?

If you choose the compress extents option on export you will need enough free space to hold the current (total extended) size of the table.

Dennis

TurkBear wrote in message <345a4107.4167833_at_news.primenet.com>...
>That should do it, if there is room in 1 extent for all the data -
>check the initial size parameter of the tablespace to be sure.
>
>John Greco
>
>stephan laue <stephan.laue_at_pdb.sbs.de> wrote:
>
>>Could anyone help me with export / import ?
>>
>>Situation:
>>a large table with many extents.
>>I plan to export and import this table, so that i get a table with only
>>one extent.
>>
>>Question: is it enough to export, than drop this table and import it
>>back in the user's scheme ?
>>
>>thank's for your help!
>>Stephan
Received on Fri Oct 31 1997 - 00:00:00 CST