Home » RDBMS Server » Server Administration » How to get the space available in a table space.
How to get the space available in a table space. [message #61984] Tue, 15 June 2004 22:54 Go to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
I want to know how much of space is left in my table space. when i query dba_extents it gives the space allocated not the space actully used.
The dba_free_space gives the free space but it is not the total free space available because allocated extents may also have some unused space.
Could you please tell me how can I get the actuall free space in my tablespace.

Report message to a moderator

Re: How to get the space available in a table space. [message #61986 is a reply to message #61984] Wed, 16 June 2004 00:26 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

It is true that DBA_FREE_SPACE will show u only that space which is not allocated by any of the segment. And if you want to reclaim the unused but allocated space from table than u can use:

ALTER TABLE TB_NAME DEALLOCATE UNSED;

This command will deallocate all the space above HWM from the table.

Daljit Singh

Report message to a moderator

Re: How to get the space available in a table space. [message #61990 is a reply to message #61984] Wed, 16 June 2004 03:59 Go to previous message
jeevan
Messages: 18
Registered: August 2001
Junior Member
hi!
execute this one under "sys" user
select * from tab where tname like '%SM%TS%';
it gives u 3 views. i hope it may helps u
regards
jeevan

Report message to a moderator

Previous Topic: Difference between dba_extents and dba_segments
Next Topic: recreating dbms_lock
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 10:26:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.