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
Messages: 12
Registered: December 2006
Junior Member
how can i find maxsize of a tablespace?
or check the tablespace has a maxsize equals unlimited?
plz help.
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

if you want to know about tablespace is size.
select tablespace_name, sum(bytes/1024/1024) from dba_data_files
group by tablespace_name;


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

Current Time: Fri Oct 28 14:44:40 CDT 2016

Total time taken to generate the page: 0.12785 seconds