Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

drop/recreate primary key index

433147Apr 1 2009 — edited Apr 1 2009

Any suggestions for dropping/recreating a primary key index? The index has to be dropped/recreated and not rebuilt due to ORA-600s.

Do I simply disable/re-enable the primary key constraint? The database is 10g.

Edited by: nickw2 on Apr 1, 2009 5:06 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 29 2009

Added on Apr 1 2009

#general-database-discussions

4 comments

11,347 views