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

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:                      <->
<->                                                               <->
<->                             <->
<->                                                               <->
<->             email:                    <->

Back to Ari Kaplan's Home Page Back to Ari Kaplan's Home Page