My tablespace almost 100GB and I cannot create another tablespace to move the tables due to space problem.

I've restarted the database but it didn't release the space.

Now I'm creating 1 small tablespace and moving 1 table to see whether it is releasing the space from the old tablespace.

ANY OTHER WORKAROUND TO RELEASE SPACE ????



Thanks,
Ano