Home -> Usenet -> comp.databases.oracle -> Corrupt Primary Key index on table causing ORA-600 internal error

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

From: Thiko <biwombi_at_hotmail.com>
Date: 1 Aug 2004 12:24:18 -0700
Message-ID: <b8d3b40c.0408011124.6283acac_at_posting.google.com> 





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 - 21:24:18 CEST












Original text of this message