Re: reclaim space

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?

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f525243$0$6528$afc38c87_at_news.optusnet.com.au...
>
> "DJ" <nospamplease_at_goaway.com> wrote in message
> news:B1q4b.2840$bC1.916_at_newsfep4-winn.server.ntli.net...
> >
> > "Joe" <yung103_at_netvigator.com> wrote in message
> > news:bit6dd$bgv1_at_imsp212.netvigator.com...
> > > Hi All,
> > >
> > > I have a tablespace, says INVX for all the indexes of the inventory
> > tables.
> > > Its size is beyond 900M.
> > > Now I move some of the indexes to a new tablespace, says INVX02, and
the
> > > totally actual size of those indexes remain in INVX drop to 500M.
> > >
> > > I would like to reclaim those 400M to make the INVX only 500M in size.
> > > I try to resize the datafile, but fails with ORA-03297: file contains
> used
> > > data beyond requested RESIZE value
> > >
> > > I search for solution on the web, and it seems to me that there is no
> easy
> > > solution to reclaim the space.
> > > However, I have a urgent need to solve this problem :(
> > >
> > > Can anyone help?
> > >
> > >
> > >
> >
> > your tablespace is fragmented it seems, move all the objects to a new
> > tablespace which is an LMT
> > then you can drop this on
>
>
> Good answer... but just remember that indexes aren't 'moved' to a new
> tablespace, but rebuilt to one. IE, you can't do 'alter index blah move
> tablespace LMT1' but only 'alter index blah rebuild tablespace LMT1'.
>
> Regards
> HJR
>
>
>
>
Received on Mon Sep 01 2003 - 04:04:49 CDT