Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> NEXT usage in CREATE TABLESPACE statement
hi,
i would like to ask how is the "NEXT" keyword in CREATE TABLESPACE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE statement used. i mean what does
it specify? the size of the first extent?
i know that in locally managed tablespaces with AUTOALLOCATE allocation
type Oracle server calculates/determines the size of the extents. does
this value specify a starter extent size?
this question came into my mind after i have read that UNDO tablespaces should use EXTENT MANAGEMENT LOCAL AUTOALLOCATE and i saw the keyword NEXT in the UNDO tablespaces DDL. by now i thought the NEXT value specified a UNIFORM extent size with locally managed tablespaces.
here is an example of such DDL:
SQL> select dbms_metadata.get_ddl('TABLESPACE','UNDO') from dual;
CREATE UNDO TABLESPACE "UNDO" DATAFILE
'some_datafile_name.dbf' SIZE 262144000 REUSE
AUTOEXTEND ON NEXT 5242880 MAXSIZE UNLIMITED
BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL
thanks for your answer in advance
Received on Tue Oct 10 2006 - 09:57:58 CDT