Re-create Primary Key

I would like to seek guru's comment on how to re-create primary key after dropping the primary key index (not table). (rule out reindex option).

I would do:

1) disable primary key related foreign constraint on child table;
2) disable primary key constaint on present table
3) drop index
4)  recreate index
5) enable all disabled constraint

Question is:
The command on "create index xxxx on table_name (a,b) tablespace kkk storage (....)" do not have primary key indicated as you have on creating primary key index based on a new table.

If primary key constraint is enabled, would that primary key function be resumed, not only the index?

Please help.

Very appreciated.

Steve Received on Wed Jun 20 2001 - 15:47:38 CDT