Oracle Database Discussions

Hi All ,


I am on oracle 11G environment using SPARC machine.


I created a tablespace yesterday with the following query :

SQL> CREATE TABLESPACE XXXX_DATA LOGGING
  2      DATAFILE     '/XXXX/XXXX/f_data01.dbf'  SIZE 512M REUSE,
  3                   '/XXXX/XXXX/f_data02.dbf'  SIZE 512M REUSE,
  4                   '/XXXX/XXXX/f_data03.dbf'  SIZE 512M REUSE,
  5                   '/XXXX/XXXX/f_data04.dbf'  SIZE 512M REUSE
  6                    EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;

It was created , but with this I found a paramter MAX_SIZE set to value : 2147483645 when i queried the tablespace using select * from dba_tablespaces where tablespace_name = ' XXXX_DATA';

I did not specify this argument. Other tablespaces that exist have this parameter set to blank.

What is the significance of this paramter. Can this be altered , set to blank ?

What if the size of the segment increase beyond this MAX_SIZE ?

I checked on google , and it said its :

MAX_SIZE NUMBER Default maximum size of segments .
(http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/statviews_5054.htm).