ALTER TABLE MODIFY ENUM takes a long time. Why?
I'm doing a MODIFY on an enum column (I typoed one of the 30 tokens). Since an enum is merely a way to name a set of integers, I thought the ALTER would finish in a flash, since all it would have to do is change the list of tokens to which the underlying integers map. But it seems to be fingering through the whole 2.3M-record table for some reason. Why would it do that, does anyone know? Surely it doesn't store the string value, does it?
Thanks for any insights.
Subject
Views
Written By
Posted
ALTER TABLE MODIFY ENUM takes a long time. Why?
15152
October 30, 2004 07:00AM
10920
October 30, 2004 10:01AM
4967
October 30, 2004 10:41AM
4061
October 30, 2004 10:42AM
4527
October 30, 2004 01:57PM
4143
August 27, 2007 04:51PM
3131
May 04, 2009 03:26AM
3058
May 04, 2009 07:15PM
2980
May 05, 2009 07:24AM
3683
May 05, 2009 07:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.