Re: export, drop, import is the way?

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