Database Backup and Recovery (MOSC)

MOSC Banner

10g SE, IOT table, block corruption

edited Nov 24, 2015 3:21AM in Database Backup and Recovery (MOSC) 7 commentsAnswered ✓

Dear community,

My DB is 10g Standard Edition and one of the database block in sysaux tablespace is corrupted. The block belongs to SYS.SYS_IOT_TOP_8829 index located on Index Organized Table SYS.AQ$_ALERT_QT_H.

If it were normal index I would be able to drop and create index to solve block corruption.

But it is index on IOT table located on PK and DB is 10g Standard Edition(Index cannot be rebuild online)... I am in trouble.

When I run:

1.

--Reorganize table to solve block corruption

alter table AQ$_ALERT_QT_H move;

--Error

ORA-08108: may not build or rebuild this type of index online   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center