>
> There's no command to do what you want to do (which is, presumably, to
> squish all the bits of remaining tables together leaving a nice big
> chunk of empty space at the end of the tablespace).
>
> If you are going to create new tables in this tablespace; or if the
> existing tables are going to grow over time, then I wouldn't
> necessarily worry about it, because Oracle will slot those new bits of
> storage into the empty space vacated by the old table. The free space
> will, eventually, get used.
>
> If it really is an issue, though, the only real way to achieve what
> you're after is to alter table X move tablespace Y... and to do that
> for every segment resident in your existing tablespace, until such
> time as the existing tablespace is empty, and you can drop it. That
> is: create a new tablespace, move everything out of the old and into
> the new; drop the old.
>
> But it's an awful lot of work for a bit of disk space...
What about ?
alter table xxx enable row movement
alter table xxx shrink space
Received on Sun Aug 12 2007 - 01:21:35 CDT
