Create tablespace app_data
Datafile 'd: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ app01.dbf' size 50 m,
'D: \ ORACLE \ PRODUCT \ 10.2.0 \ ORADATA \ EDWTEST \ APP02.DBF 'size 50 m
Minimum extent 500 k
Default storage (initial 500 k
Next 500 k
Minextents 3
Maxextents 500
Pctincrease 50 );
Table space name: app_data
Tablespace contains data files: APP01.DBF and APP02.DBF
Parameter description:
INITIAL: initial defines the size of the first partition (extent). The first partition (extent) requires at least two blocks, that is, 2 * DB_BLOCK_SIZE. the default size of the first partition (extent) is 5 blocks ).
NEXT: next specifies the size of the second partition (extent). The second partition (extent) requires at least one block ),
The default value is 5 blocks ).
MINEXTENTS: specifies the minimum number of allocated zones (extent) when a segment is created. The minimum and default values are 1.
MAXEXTENTS: determines the maximum value of the partition (extent) that a segment can own. The size of this parameter depends on the size of the block. if MAXEXTENTS is specified with the keyword UNLIMITED, the value is equal to 2147483645.