切换主键的类型（因为存在约束）

ALTER TABLE GAP_UI_BUTTON_WF_STATUS DROP PRIMARY KEY;
alter table GAP_UI_BUTTON_WF_STATUS	rename column BUTTON_ID to BUTTON_ID_tmp;
alter table GAP_UI_BUTTON_WF_STATUS	add BUTTON_ID varchar2(100);
update	GAP_UI_BUTTON_WF_STATUS	set  BUTTON_ID=BUTTON_ID_tmp;
alter table	GAP_UI_BUTTON_WF_STATUS	drop column	BUTTON_ID_tmp;
alter table	GAP_UI_BUTTON_WF_STATUS	add constraint	GAP_UI_BUTTON_WF_STATUS	primary key(BUTTON_ID,WF_STATUS);