Red Gate forums :: View topic - Initial and next extent attributes lost from indexes
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Initial and next extent attributes lost from indexes

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
paulhome



Joined: 06 Sep 2013
Posts: 4

PostPosted: Fri Sep 06, 2013 1:22 pm    Post subject: Initial and next extent attributes lost from indexes Reply with quote

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
)
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Mon Sep 09, 2013 2:22 pm    Post subject: Reply with quote

Hi,

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

Neil
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group