Re: Next Extent Size of an index

Thank you very much Fernando. I have a similar problem, but with fragmented tables. I have 4 tables fragmented (per year), and each year I have one dbspace for data and one for indexes. I have problem when setting the extent size of each table, each year. The extents size of some indices is too big. The problem is that being fragmented tables, I can not create the index whenever I alter the extent size Anyway, I'll see how to solve the problem. With the information you have given to me I have a lot to work with. Regards