Re: reclaim space

"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 Sun Aug 31 2003 - 14:51:57 CDT