469,600 Members | 2,281 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,600 developers. It's quick & easy.

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!
Jul 19 '05 #1
1 5401
bi*****@hotmail.com (Thiko) wrote in message news:<b8**************************@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!


Thiko, dropping and re-creating the PK will probably correct the
situation since from your information it appears to be just a
corrupted index. Depending on the type of replication in use and
hardware capacity re-creating the PK could be a 30 second to 10 minute
operation so turning of the replication may not even be necessary if
you are on the low end of the scale.

I would think a complete refresh might be an option.

By the way when a newsgroup has subgroups you should generally post in
the appropriate subgroup and not in the base group.

HTH -- Mark D Powell --
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Haider Kazmi | last post: by
17 posts views Thread by Philip Yale | last post: by
4 posts views Thread by Peter Scott | last post: by
8 posts views Thread by Paul Hunter | last post: by
3 posts views Thread by vj_dba | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.