reclaim space

From: Joe <yung103_at_netvigator.com>
Date: Mon, 1 Sep 2003 00:06:08 +0800
Message-ID: <bit6dd$bgv1@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? Received on Sun Aug 31 2003 - 11:06:08 CDT