Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: reclaim space
I got it
Thanks for your information
Best Regards,
Joe
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> ¼¶¼g©ó¶l¥ó·s»D
:3f531470$0$10355$afc38c87_at_news.optusnet.com.au...
>
> "Joe" <joe.yung_at_ecl-consulting.com> wrote in message
> news:3f530bed$1_at_newsgate.hknet.com...
> > I am thinking if "alter table move" or "alter index rebuild" will move
the
> > data to the front end of a local managed datafile?
> > and then i coalesce the datafile and resize it.
> >
> > It is possible?
> >
>
> No. Move and rebuild will place the data wherever Oracle deems it
> appropriate, and that is rather more likely to be at the back-end of the
> data file than the front.
>
> The suggestion was that you should create a brand new tablespace, and move
> and rebuild into that, then drop the original tablespace... and I'd agree
> that's going to be the best way of achieving what you want.
>
> Regards
> HJR
>
>
Received on Mon Sep 01 2003 - 06:30:56 CDT