MAXSIZE 32767M

From: sol beach <sol.beach_at_gmail.com>
Date: Thu, 3 Aug 2006 10:17:55 -0700
Message-ID: <40a16b360608031017s7866f3d9oef369beb1381b793@mail.gmail.com>

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

Received on Thu Aug 03 2006 - 12:17:55 CDT