Oracle not releasing space after DROP TABLE
We have a few big tables in a schema. Now when we are dropping the tables the space acquired by the tables is not released by ORACLE. When we try to resize the datafile of that schema, it is not allowing us to do it and throwing an error.
But we need the space to be released and allocated to some other schema.
We are using ORACLE 220.127.116.11 on LINUX AS 2.1 on ITANIUM server.
Please give and workaround for this problem.
Thanks in advance,
Click Here to Expand Forum to Full Width