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