ORA-08102 troubleshooting

Source: Internet
Author: User

ORA-08102 troubleshooting

Two ORA-08102 errors today When deleting table data

When the following statement is executed:

Delete from tb_ware w where w. issue like '% 100 ';

The following error occurs;

ORA-08102: index key not found, obj #57848, file 6, block 6324 (2)

**************************************** ***************************************
/* Cause: Internal error: possible inconsistency in index

// * Action: Send trace file to your customer support representative, along
// With information on reproducing the error

**************************************** ***************************************

ORA-08102 errors indicate that the index or table data is inconsistent, the key value recorded on the index is inconsistent with the data in the table, causing access failure, the general re-index can solve


Solution 1:

SELECT owner, object_name, object_type
FROM Dba_Objects
WHERE object_id IN (57848 );

You can find out the object_name and the index of the table TB_WARE, and then re-create the index.

Alter index PK_TB_WARE rebuild online; (remember to use rebuild online because he will re-read the table to create an index, and rebuild may read the original index segment instead of reading the table)

Please note, don't stop it manually at this time. If you do that, you will encounter a ora-08104.

If the problem persists, delete and recreate the instance.

Select index_name, column_name from all_ind_columns
Where index_name = 'pk _ TB_WARE ';


Drop index PK_TB_WARE;

Create index PK_TB_WARE on tb_ware (id );

Solution 2:

Analyze table t validate structure cascade

Check the completeness of the row data in the table, check the table or index structure, and write the analyzed results to the INDEX_STATS data dictionary.

I did not try this method. I tried to reproduce the problem again, and I did not try it several times.

---------------------------------

Now back to my problem, after I rebuild an index online, it prompts that there is a problem with the next index. I simply rebuild all the indexes in this table online.

Check the index of the table.


Select * from user_indexes t where t. table_name = upper ('tb _ ware ')

Run the following statement:

Alter index PK_TB_WARE rebuild online;
Alter index AK_TB_WARE rebuild online;
Alter index IDX_TB_WARE_PRINTSTATE rebuild online;
Alter index IDX_WARE_END_TIME rebuild online;
Alter index IDX_WARE_LOTTERY_ID rebuild online;
Alter index IDX_WARE_LOTTERY_STATE rebuild online;
Alter index IDX_WARE_TEAM_NAME rebuild online;


Use this table again, or there is no ORA-08102 error in alert. log

--- End ----

Migration from 32-bit to 64-bit for a single Oracle instance

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.