Partition Index Problem

[M.Shakeel Azeem]

Dear Sir Please take a look at the attachment and plz suggest where is the problem
i am in greate trouble
can u plz help me in this regard?

Somebody was saying that it is problem in tablespace
but i'll not agree with him
Because i didn't do anything with tablespace
Last time we have moved tables to different tablespace as well as rebuild indexes
is it the reason that some partition of indexes are not moved and become unusable
if it is understandable for u then plzz help me in this regard
it is very urgent Sir

[yxez]

ma'm correction....well, if i were in ur place i'll drop and recreate
the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience

[davey23uk]

what are you talking about? there is no attachment and your post doesnt make any sense

[yxez]

sorry davey...but his english is not so clear ....as what my understanding is...that the indexes where unusable after he moved
the tables....so the option is to recreate them.

[slimdave]

ma'm correction....well, if i were in ur place i'll drop and recreate
the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience

... but more error prone and difficult to code, I'd say

[waitecj]

ma'm correction....well, if i were in ur place i'll drop and recreate
the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience

Drop and re-create will mean you are doing a full table scan of the table the index is based on.

Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks).

I'd rebuild it if I could.

[slimdave]

Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks).

Not if the index is unusable.

[waitecj]

Duh! Silly me. Next time i'll read the post a little more carefully before responding.

I even said "assuming Oracle can read all the blocks" in my original reply!!

[yxez]

thanks voyz ....david, do you mean that im right and not wild?

[slimdave]

thanks voyz ....david, do you mean that im right and not wild?

You haven't fully explained your problem yet. There is no attachment to your post.