-
Hiii,i get frequently above error,
Every time i am rebuild the index,then
i was solve the problem.
Why this error occur?
Is there any permenent solution to overcome this problem.
thanks
kavitha
-
ORA-01502 index 'string.string' or partition of such index is in unusable state
Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation.
Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.
Sanjay
-
So find out which action caused the index be in invalid mode?
when was the last ddl, get the root cause and solve it.
www.cnoug.org
-
I'm sorry I can't recall it completely,
but we had the same problems too.
It was cased by a pretty complicated DML-query,
including user-function , inner selects, etc.
Every time a batch-procedure ran, it had the same problems.
I rewrote the query avoiding complex retrieve queries.
Try to locate the problem statement in it.
Good luck
Regards
Ben de Boer
-
Are you either,
a). Doing partition manipulation?
b). Perfoming Direct Imports?
OCP 8i, 9i DBA
Brisbane Australia
-
Originally posted by grjohnson
Are you either,
a). Doing partition manipulation?
b). Perfoming Direct Imports?
hei,
there is no concept like direct import, just direct load?
www.cnoug.org
-
[/B][/QUOTE]
hei,
there is no concept like direct import, just direct load? [/B][/QUOTE]
Yes, yes, yes... nice pick up.
Sorry, typo, Direct SQLLDR loads, is what I should've say.. Cheezzzz!
OCP 8i, 9i DBA
Brisbane Australia
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
|