Home » RDBMS Server » Server Administration » find maxsize of a tablespace
find maxsize of a tablespace [message #218783] Sat, 10 February 2007 03:21 Go to next message
baju
Messages: 12
Registered: December 2006
Junior Member
hi,
how can i find maxsize of a tablespace?
or check the tablespace has a maxsize equals unlimited?
plz help.
thanks

Report message to a moderator

Re: find maxsize of a tablespace [message #218793 is a reply to message #218783] Sat, 10 February 2007 06:13 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member
Hi,
if you want to know about tablespace is size.
[pre]
select tablespace_name, sum(bytes/1024/1024) from dba_data_files
group by tablespace_name;

[/per]



regards
Taj

Report message to a moderator

Previous Topic: Reg Buffers
Next Topic: Special characters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 01:50:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.