Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NEXT usage in CREATE TABLESPACE statement

NEXT usage in CREATE TABLESPACE statement

From: <ora_question_at_yahoo.co.uk>
Date: 10 Oct 2006 07:57:58 -0700
Message-ID: <1160492278.697939.49480@b28g2000cwb.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US