Partition Index Problem

Printable View

10-06-2006, 01:50 AM
M.Shakeel Azeem

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
10-06-2006, 02:06 AM
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 :)
10-06-2006, 04:13 AM
davey23uk

what are you talking about? there is no attachment and your post doesnt make any sense
10-06-2006, 04:33 AM
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.
10-06-2006, 09:07 AM
slimdave

Quote:

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
10-06-2006, 10:29 AM
waitecj

Quote:

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.
10-06-2006, 11:26 AM
slimdave

Quote:

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.
10-06-2006, 11:48 AM
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!!
10-07-2006, 05:14 AM
yxez

thanks voyz :) ....david, do you mean that im right and not wild?
10-07-2006, 02:35 PM
slimdave

Quote:

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.
10-08-2006, 10:21 PM
yxez

Quote:

Originally Posted by 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

ohhh dear me...u guys are sometimes funny :D
The attachment he referred to was the 2nd paragraph in his post.
How can u expect a beginner to make attachment, I myself does't
even know how to do it :)
10-09-2006, 04:43 AM
davey23uk

i usppose you cant see the 'manage attachments' in the reply option.

Just because you cant see it says doesn't say anything about the intelligience of everyone else
10-09-2006, 05:00 AM
yxez

Thanks for the tips davey...but in general beginners dont explore
much of the features here...coz they are concen with their
problem post only. I bet on it 100% that Shakeel doesnt know
how to attach files here :D

Wait...i try if i can attach something...
10-09-2006, 05:03 AM
yxez

why does my attachments does not show :confused:
I click manage attachment....then browse....then upload...then close...then submit....and nothing is there :rolleyes:
10-09-2006, 05:09 AM
yxez

test again...oh it said invalid file type :confused: does not it allow .htm file type?
10-09-2006, 05:24 AM
yxez

Davey....I think theres a bug in this forum....do u noticed my post
counter(n) ? It doesnt accumulate, I've been answering lots of
posts here but my counter is still low....I want to be of 'Advisor'
status too, :) How much do i still have to earn? Can u promote me
instead? After all im ur avid fan here.

Thanks