create table new_tbl_user
(
USERID NUMBER(5) NOT NULL,
THIRDPARTY NUMBER(3) NOT NULL,
MAXUSERS NUMBER(10) NOT NULL,
CURUSERS NUMBER(10) NOT NULL,
AUTHMETHOD NUMBER(5) NOT NULL,
AUTHREALM VARCHAR2(32) NOT NULL
)insert into new_tbl_user select * from tbl_user;rename new_tbl_user to tbl_user;
(
USERID NUMBER(5) NOT NULL,
THIRDPARTY NUMBER(3) NOT NULL,
MAXUSERS NUMBER(10) NOT NULL,
CURUSERS NUMBER(10) NOT NULL,
AUTHMETHOD NUMBER(5) NOT NULL,
AUTHREALM VARCHAR2(32) NOT NULL
)insert into new_tbl_user select * from tbl_user;rename new_tbl_user to tbl_user;
然后insert into new table select * from old table
alter 是不行的
呵呵
速度应该不会慢吧 表有多少纪录
只有这个办法了
alter table tbname add column coltemp varchar2(32);
update tbname set coltemp=AUTHREALM;
update tbname set AUTHREALM='';
alter table tbname modify(AUTHREALM varchar2(32));
update tbname set AUTHREALM=coltemp;
alter table tbname drop column coltemp;