This content has been marked as final. Show 9 replies
This indicates a possible corrupt index on the table.
issue the following command for each index on the table:
alter index index_name rebuild;
be sure to include the primary key is there is one.
I'd try rebuilding all user indexes
I'd run the srcipt resulting of
select 'ALTER INDEX '||INDEX_NAME||' rebuild tablespace '||tablespace_name||';' from user_indexes;
apparently all indexes were rebuilted but the error persist;
do you have another idea.
Oracle states that it is an internal error and you need to contact Oracle support and provide them with a trace file ... which I am trying to help you avoid.
Do a select on all_objects
If this returns an index or contraint belonging to the affected table then try dropping then recreating the object. If it's not or you can't then you are going to have to raise a TAR. (I suspect there solution would be the same as mine).
You don't need to rebuild all indexes, you need to rebuild the index with the given object id.
Also standard offline REBUILD may read the existing index (warts and all) - try REBUILD ONLINE option.
This problem comes when we are trying to delete records using ROWID.
So the solution is drop or make the index invalid and execute the delete statements.
Post Operating System (OS) name & version for DB server system.
08102, 00000, "index key not found, obj# %s, file %s, block %s (%s)" // *Cause: Internal error: possible inconsistency in index // *Action: Send trace file to your customer support representative, along // with information on reproducing the error
Post results of
SELECT * from v$version
I found the same problem.
The solution was to rebuild online the index.
After that it worked fine.
I had the same problem, dropping and creating index helped. But I don't know reason, why this happened - index was OK for long time..
Yes I agree. I ran a REBUILD ONLINE on the indexes associated to the table I'm trying to delete the records off and it ran without a hitch.
Here's the SQL I ran to generate the rebuild online indexes script:
select 'ALTER INDEX '||INDEX_NAME||' rebuild online tablespace '||tablespace_name||';' from user_indexes where TABLE_NAME = 'WEEKLY_FAILED_DATA';
Free Backlink http://www.web-backlinks.com/
Edited by: ariel on Jun 1, 2011 9:36 AM