RE: MAXSIZE 32767M

First guess: DBA_DATA_FILES.MAXBYTES  

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

Ours is the age that is proud of machines that can think and suspicious
of men who try to.  --H. Mumford Jones, 1892-1980

 

________________________________

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of sol beach
Sent: Thursday, August 03, 2006 1:18 PM
To: oracle-l
Subject: MAXSIZE 32767M


SQL> set long 30000
SQL> select dbms_metadata.get_ddl('TABLESPACE','USERS') from dual;

DBMS_METADATA.GET_DDL('TABLESPACE','USERS')
------------------------------------------------------------------------
--------

  CREATE TABLESPACE "USERS" DATAFILE


  '/a/oracle/oradata/cm10gu/users01.dbf' SIZE 5242880

  AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M
  LOGGING ONLINE PERMANENT BLOCKSIZE 8192
  EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
   ALTER DATABASE DATAFILE


  '/a/oracle/oradata/cm10gu/users01.dbf' RESIZE 3675258880




What view contains the "MAXSIZE 32767M" value??


TIA


--
http://www.freelists.org/webpage/oracle-l