Can anyone help me on the following questions:
Q1. Does storage clause only used in dictionary managed tablespace?
Q2. CREATE TABLE test_storage
( . . . )
STORAGE (INITIAL 100K NEXT 120K
MINEXTENTS 2 MAXEXTENTS 5
In this case, what is the 1st extent size? 100k or 200k? What's the 2nd? 120k or 240k (because the MINEXTENTS is 2)?
If the answer is "100k and 120k", what's the use of MINEXTENTS?
Thanks very much!