Re: 'Coalesce' indexes tablespace pre-7.3

Hi Jeff,

Since you are able to drop and recreate your indexes I suspect that your problem can most easily be solved by modifying your index create statement to include storage clauses with an INITIAL extent set large enough to contain your index. (The NEXT value can then be set to hold the next several days, weeks,
months worth on index entries -- it depends on how often you feel like reorganizing them.)

Regards

Jerry

GT Jeff Cherer wrote:
>
> new (to oracle - actually have been on the planet for quite some time) geek
> here.
>
> running 7.1 and have a tablespace that is pure indexes.
> it is running low on freespace and is honeycombed.
>
> well, ya can't export/import a ts; and i can't export/import index objects
> (without going thru trickery and deceipt, you know what i mean). so, i drop
> all the indexes (except a couple of pk's that i need up), and recreate them.
> very minimal effect on the problem.
>
> adding space will put off the freespace problem, but it won't do much for
> the honeycomb problem.
>
> surely, someone has dealt with this situation. please, some advice.

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group