Home » RDBMS Server » Server Administration » More Space after Deleting Data (Oracle 9i)
More Space after Deleting Data [message #354311] Fri, 17 October 2008 10:45 Go to next message
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 messageGo to next message
Michel Cadot
Messages: 64103
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

Re: More Space after Deleting Data [message #354316 is a reply to message #354313] Fri, 17 October 2008 11:54 Go to previous message
Bonita
Messages: 32
Registered: June 2008
Member
Thanks, Michel. You're best.
Previous Topic: Finding Semaphore id for one database in a server
Next Topic: Cloning database - Recreate undo
Goto Forum:
  


Current Time: Sat Dec 03 12:08:12 CST 2016

Total time taken to generate the page: 0.12108 seconds