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
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
Previous Topic: Reg Buffers
Next Topic: Special characters
Goto Forum:
  


Current Time: Sun Dec 11 02:29:56 CST 2016

Total time taken to generate the page: 0.04244 seconds