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 18.104.22.168 on LINUX AS 2.1 on ITANIUM server.
Please give and workaround for this problem.
Thanks in advance,