OraFAQ Forum: Server Administration » Compact DB size after delete data

Home » RDBMS Server » Server Administration » Compact DB size after delete data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Compact DB size after delete data [message #141341]

Sun, 09 October 2005 11:14

bornlooser
Messages: 20
Registered: September 2005
Location: Jakarta

Junior Member

Hi All,

In MS-access after deleting the rows from tables we have to run the 'Compact Database' utility to get the left over space by deleted rows. what I have to do in case of oracle ...

pls advise

bonny

Report message to a moderator

Re: Compact DB size after delete data [message #141348 is a reply to message #141341]

Sun, 09 October 2005 14:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You don't have to do anything in Oracle after doing a DELETE.

Report message to a moderator

Re: Compact DB size after delete data [message #141380 is a reply to message #141348]

Sun, 09 October 2005 23:58

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

To add something more in the discussion

If you are truncating a table in Oracle then you dont have to do anything because this command will bring down the HWM(High Water Mark) itself.


 SQL> truncate table table_name;

But if you are deleting rows from a table then Oracle will not bring the HWM down.

SQL> Delete from table_name;

can read this link.

http://www.dbasupport.com/oracle/ora9i/DeleteHistoricalData01.shtml

Report message to a moderator

Previous Topic:	Reuild a database from it's files
Next Topic:	undo tablespace error while executing Alter statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 13:58:34 CST 2025