storage parameters 1

[stu78]

Hi,

Could someone explain what this means please?

STORAGE (
INITIAL 100k
NEXT 100k
MINEXTENTS 1
MAXEXTENTS 100
)

Thanks,
Stu

 

[ikkyu65]

You have a storage definition clause. You can specify this when you create a segment definition (a logical structure of storage) in CREATE TABLESPACE. Also, you can put this clause in a CREATE TABLE/INDEX... in order to override the tablespace storage parameters asumed as default for every object inside it (with certain restrictions). I think you can find information of this without problem. Shortly,
INITIAL is the first extent size (n * DB_BLOCK_SIZE)
NEXT is the size of second, third... extensions (when the object is growing.
MINEXTENS, the minimum number of extents by segment (when the segment is created) In others words, number of INITIAL.
MAXEXTENS is the limit of extents by segment.

Please, forgive my owful english.
Greetings.

 

[stu78]

Thanks ikkyu65,
I appreciate your answer.