To: Rao Uppuluri
> Hi
>
> Firstly great web site and wonderful tips! I have question on Indexes. When I
> export my database and create a index file from it, it creates a script with
> one big INITIAL extent for each index. But what I found for most of my indexes
> is that the INITIAL extent is too big for what they actually need. I tested
> that by changing the script and using smaller values for INITIAL extent. How
> do I get the right number for the INITIAL extent for indexes?
>
> Thank you very much for your help
>
> Rao Uppuluri
>
--------------------------------------------------------------------------
Rao,
Glad that you like my web page. I do it for fun so I love getting positive
feedback. As for your question, by default EXPORT/IMPORT compresses
objects into one large INITIAL extent.
To prevent this from happening, when you export specify "COMPRESS=N". This
time, when you use the INDEXFILE, the INITIAL/NEXT will be what it
currently is in the database.
Best regards,
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 310+ Oracle tips, visit my Web Page: <->
<-> <->
<-> http://www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page