OraFAQ Forum: Server Utilities » Releasing the Table space after /while deleting records

Home » RDBMS Server » Server Utilities » Releasing the Table space after /while deleting records

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

Releasing the Table space after /while deleting records [message #70724]

Wed, 17 July 2002 23:00

Vijay
Messages: 116
Registered: September 1999

Senior Member

Hello,
Is there a simple way to release the table space after or while deleting the records? Truncate is not an option as we don�t want to take the table offline while truncating.

Thanks,
Vijay

Report message to a moderator

Re: Releasing the Table space after /while deleting records [message #70725 is a reply to message #70724]

Thu, 18 July 2002 05:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

alter table table_name deallocate unused;
or
alter table table_name deallocate unused keep nnn;

Report message to a moderator

Re: Releasing the Table space after /while deleting records [message #70727 is a reply to message #70724]

Thu, 18 July 2002 05:42

denise
Messages: 64
Registered: November 2000

Member

also Truncate alleviates the need to issue COMPACT
command to reclaim and reuse storage.

Report message to a moderator

Re: Releasing the Table space after /while deleting records [message #70729 is a reply to message #70724]

Thu, 18 July 2002 08:19

Vijay
Messages: 116
Registered: September 1999

Senior Member

Thanks, It worked.
Regards,
Vijay

Report message to a moderator

Re: Releasing the Table space after /while deleting records [message #70745 is a reply to message #70724]

Fri, 19 July 2002 15:48

ctg
Messages: 146
Registered: July 2002

Senior Member

this does not free any space that the deleted rows consumed. this frees space that was above the high water mark (never used). Any space that was once stored a row (used) will not be freed with this command.

Report message to a moderator

Previous Topic:	Re: Releasing the Table space after /while deleting records
Next Topic:	Re: urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 06:57:35 CST 2024