Initial and next extent attributes lost from indexes

paulhome

When an index is scripted, the initial and next extents are lost.
E.g
create index xyz......
STORAGE (
INITIAL 16K
NEXT 8K
MAXSIZE UNLIMITED
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)

becomes

STORAGE (
INITIAL 64K
NEXT 1M
MAXSIZE UNLIMITED
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)

neil.anderson

Hi,

Thanks for this. I'll investigate this and the other problem you reported with NOLOGGING and get back to you.

Neil