More Space after Deleting Data [message #354311] |
Fri, 17 October 2008 10:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Bonita
Messages: 32 Registered: June 2008
|
Member |
|
|
I used Oracle 9i in my desktop, and I am newbie to Oracle.
I deleted 1M rows from Table A . The commands are
SQL> Delete from A;
SQL> Commit;
Before I deleted date, the hard drive space has 5G available. I was assuming its free space would be more than 5G. However, after deleting and committing, I found that the free space is 3.7G. My question is how to permanently delete data from Oracle in order to get more space. What command(s) I should use.
Thank you very much for your reply and helps.
|
|
|
Re: More Space after Deleting Data [message #354313 is a reply to message #354311] |
Fri, 17 October 2008 10:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68680 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Delete does not free space.
Rebuild the indexes, recreate the tables, move the objects in order to shrink the files, export the objects, drop them, recreate the tablespaces, reimport the objects.
Those some ways to get back space but the wisest way is to buy a new drive.
Regards
Michel
[Updated on: Fri, 17 October 2008 10:57] Report message to a moderator
|
|
|
|