Initial and next extent attributes lost from indexes

Track changes to Oracle schemas in your existing version control system.

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Initial and next extent attributes lost from indexes

Postby paulhome » Fri Sep 06, 2013 1:22 pm

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
 
Posts: 4
Joined: Fri Sep 06, 2013 1:14 pm

Postby neil.anderson » Mon Sep 09, 2013 2:22 pm

Hi,

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

Neil
neil.anderson
 
Posts: 64
Joined: Tue Sep 28, 2010 2:17 pm


Return to Source Control for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests