Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

MAX_SIZE Column in DBA_TABLESPACES

RijuJul 30 2014 — edited Jul 31 2014

Hi,

I have a general question regarding the understanding of the DBA_TABLESPACE dictionary. I created a tablespace using the following command

CREATE TABLESPACE HOME_DB DATAFILE

'C:\APP\PRITHWISH\ORADATA\ORCL\HOME_DB01.DBF' SIZE 20480M AUTOEXTEND ON NEXT 8K MAXSIZE 30720M

LOGGING

ONLINE

EXTENT MANAGEMENT LOCAL AUTOALLOCATE

BLOCKSIZE 8K

SEGMENT SPACE MANAGEMENT AUTO

FLASHBACK ON;

When I query the DBA_DATA_FILES all the statistics are pretty clear to me. However when I query the DBA_TABLESPACE I get the max_size parameter as 2147483645. All my other tablespaces like the USERS,EXAMPLE,SYSTEM have the same number.
Could you please tell me what does this column signify. The documentation states that it is the maximum size of the segments in the tablespace but I would like to understand in detail what that means and how is it different from my data file size.


I am running a 8K block database Oracle 11g R2.


Thanks in advance

Prithwish

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2014
Added on Jul 30 2014
2 comments
5,600 views