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: 330
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: 22925
Registered: January 2009
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: 59496
Registered: March 2007
Location: Nanterre, France, http://...
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: 22925
Registered: January 2009
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: Thu Oct 30 08:10:33 CDT 2014

Total time taken to generate the page: 0.07276 seconds