Home » RDBMS Server » Server Administration » How to free disk space.
How to free disk space. [message #197416] Wed, 11 October 2006 03:44 Go to next message
Messages: 4
Registered: September 2006
Location: Malaysia
Junior Member
Hi there,
This really sounds stupid but i would like to know how to free some space from the server. I tried to truncate/drop alot of tables(big tables with more than 1 million record) but still end up the disk space still the same. What am i missing here? From the documents that i see, the high water mark will reset after i truncate the table. I also did try to use
ALTER TABLE table DEALLOCATE UNUSED, but still nothing happened. Can anyone give me some hint or what to look for in order to free hard disk space. Thanks alot...

Re: How to free disk space. [message #197433 is a reply to message #197416] Wed, 11 October 2006 04:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Truncate / drop will release the space. But only within the datafiles. In other words, the allocated datafile size remains the same. You need to manually reduce the datafile size.
Search the board for examples.
Previous Topic: Inserting Data become Slow why?
Next Topic: ORA-00600 Internal Error
Goto Forum:

Current Time: Sat Oct 22 22:10:25 CDT 2016

Total time taken to generate the page: 0.08979 seconds