Hi Friends.........
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
thanks...............
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Nov 21, 2011, 1:38 AM
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 MishraPosted Nov 21, 2011, 3:58 PM