What are the challenges you face when working across database platforms? Take the survey
Options

Initial and next extent attributes lost from indexes

paulhomepaulhome Posts: 7
edited September 9, 2013 9:22AM in Source Control for Oracle
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
)

Comments

Sign In or Register to comment.