dba_data_files. you have specified unlimited for max size when
creating the datafile. unlimited means the maximum no of blocks
multiplied by the block size of the ts. so you have a smallfile ts
with iirc a 16k blocksize.
On 8/3/06, sol beach <sol.beach_at_gmail.com> wrote:
> 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
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 03 2006 - 12:50:01 CDT
