SQL Extensions   «Prev 

Create Space Syntax

Create space syntax

(column specifications) Here is where you place your list of columns, the datatype, and column constraints. For example:
(PRODUCT_ID NUMBER(10,2),
PRODUCT_NAME VARCHAR2(50), …)
[PCTFREE n] Percent of space saved for updates of current rows in the block.
[PCTUSED n] Maximum percent used before no more rows can be inserted into the block.
INITIAL nK Initial extent size.
NEXT nK Next extent size.
MINEXTENTS n|UNLIMITED Minimum extents to create when the table is created.
MAXEXTENTS n Maximum extents allowed. Specify a number or the word UNLIMITED.
PCTINCREASE n Percent increase of each subsequent extent over the previous one.
tablespace_name