Primary key constrain

Question

Hi Friends......... What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause ? thanks...............

Pravin More · Answer

Hi Vikas The index is created in the user's default tablespace and all sizing information is lost. database enviroment doesn't store this information as a part of the constraint definition but only as part of the index definition when the constraint was disabled the index was dropped and the information is gone. Thanks Pravin.

Vikas Mishra · Answer

thanks pravin.........