How can we help you today? How can we help you today?

Initial and next extent attributes lost from indexes

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
)
paulhome
0

Comments

1 comment

Sort by
  • neil.anderson
    Hi,

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

    Neil
    neil.anderson
    0

Add comment

Please sign in to leave a comment.