difference b/w alter table drop primary key and disable

From: <ajayanand_at_my-dejanews.com>
Date: Tue, 10 Nov 1998 15:06:59 GMT
Message-ID: <729kqj$h6f$1@nnrp1.dejanews.com>

Hi!

Is there any significant difference b/w alter table drop primary key and alter table disable primary key ?

I am doing to update primary key field of around 4 million records into a table and before that I wish to disable primary key. I think Oracle recreates index when I enable it and the only difference is this that the definition is maintained in case of disable, whereas if dropped I would have to respecify the definition. Is this right ?

So what should I use? Please suggest.

Thanks

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 09:06:59 CST