-
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 9.2.0.5 on LINUX AS 2.1 on ITANIUM server.
Please give and workaround for this problem.
Thanks in advance,
Anomitro
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|