Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compact a Tablespace?
Hi Adrian,
try "alter tablespace ... coalesce" from an user with admin privileges.
> Adrian Harrison wrote in message <37c11549.81624820_at_news.globalnet.co.uk>...
> >Using Oracle 7.3.4
> >
> >I have a tablespace (size = 30 meg), that I've just deleted probably 90% of
> the contents.
> >
> >Using the Navigator Tool that comes with Personnel Oracle the "Used Space"
> & "Free Space" hasn't
> >changed at all for this tablespace.
> >
> >All the deletions were definetely committed so what I'm wondering is if I'm
> supposed to do some sort
> >of "compact" to free this space up!
> >
> >Any ideas?
> >
> >Thanks
> >
> >Adrian Harrison
Received on Mon Aug 23 1999 - 08:19:19 CDT