Home » RDBMS Server » Server Administration » space reclaim (10.2.0.4)
space reclaim [message #530480] Tue, 08 November 2011 09:05 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I have one basic question.
When we bring high water mark down
with following commands like:-
exp/imp
alter table tname shrink space;
alter table tname move tablespace;
Will it reclaim space physically on the disk also?


Thanks,
Varun
Re: space reclaim [message #530481 is a reply to message #530480] Tue, 08 November 2011 09:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Will it reclaim space physically on the disk also?
no, the space on the disk volume remains the same
Re: space reclaim [message #530495 is a reply to message #530480] Tue, 08 November 2011 10:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
The only way to reclaim (apart from dropping the tablespace) is to shrink (resize) the files.

Regards
Michel
Re: space reclaim [message #530498 is a reply to message #530495] Tue, 08 November 2011 10:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

what is OS name & version?
Previous Topic: DBMS_LOCK_ALLOCATED
Next Topic: OEM and Audit Vault
Goto Forum:
  


Current Time: Fri Nov 29 04:36:35 CST 2024