Re: reclaim space

From: DJ <nospamplease_at_goaway.com>
Date: Sun, 31 Aug 2003 18:14:06 +0100
Message-ID: <B1q4b.2840$bC1.916@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 Received on Sun Aug 31 2003 - 12:14:06 CDT