-
Partition Index Problem
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
-
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
Last edited by yxez; 10-06-2006 at 02:09 AM.
Behind The Success And Failure Of A Man Is A Woman
-
what are you talking about? there is no attachment and your post doesnt make any sense
-
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.
Behind The Success And Failure Of A Man Is A Woman
-
Originally Posted by 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
... but more error prone and difficult to code, I'd say
-
Originally Posted by 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
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.
Assistance is Futile...
-
Originally Posted by waitecj
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.
-
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!!
Last edited by waitecj; 10-06-2006 at 11:51 AM.
Assistance is Futile...
-
thanks voyz ....david, do you mean that im right and not wild?
Behind The Success And Failure Of A Man Is A Woman
-
Originally Posted by yxez
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|