Corrupt Primary Key index on table causing ORA-600 internal error

Hi

I have a corrupt PK index on a table column. It is a unique PK. It needs to be dropped and recreated to cure the corruption.

The table is on a backup database which is in replication having records added to it to keep the two databases in sync.

Am I correct in think that if I:

1. Suspend the replication so no data inconsistency happens on the table while the PK is disabled.
2. Disable the corrupt PK on the table - then the index will get dropped?
3. Enable the PK on the table - and the index will get rebuilt with the corruption gone?
4. Re-enable the replication.

All will be fine? The table has over 9million rows so I realise it will take a while to re-enable the primary key but as is is a backup database in replication performance to users won't be affected.

Many thanks! Received on Sun Aug 01 2004 - 14:24:22 CDT