--将想调整后的顺序新建一张表
-- Create table
create table T_EVALUATION_GRADE_HIS1
(
ID NUMBER(11),
PRODUCT_TYPE NUMBER(2),
PRODUCT_NAME VARCHAR2(128),
PRODUCT_STAND VARCHAR2(4000),
VALID_DATE TIMESTAMP(6),
IS_ONLINE NUMBER(1) default 0,
PHASE NUMBER(2) default 1,
SYMBOL NUMBER(1) default 1,
OPERATE_OP NUMBER(11),
OPERATE_NAME VARCHAR2(64),
OPERATE_DATE TIMESTAMP(6) default sysdate,
ACCEPT_OP NUMBER(11),
ACCEPT_NAME VARCHAR2(64),
ACCEPT_DATE TIMESTAMP(6),
GRADE NUMBER(2),
IDEA VARCHAR2(1024),
PRODUCT_MODEL VARCHAR2(256),
VALID_DATE_START TIMESTAMP(6),
EVALUATION_UNIT VARCHAR2(256),
HID NUMBER(11),
HISTORY_OP NUMBER(11),
HISTORY_NAME VARCHAR2(32),
HISTORY_DATE TIMESTAMP(6),
HIS_TYPE NUMBER(1)
);
--复制老表数据到新表
insert into bemms.t_evaluation_grade_his1
(
id,
product_type,
product_name,
product_stand,
valid_date,
is_online,
phase,
symbol,
operate_op,
operate_name,
operate_date,
accept_op,
accept_name,
accept_date,
grade,
idea,
product_model,
valid_date_start,
EVALUATION_UNIT,---新字段
hid,
history_op,
history_name,
history_date,
his_type
)
select
id,
product_type,
product_name,
product_stand,
valid_date,
is_online,
phase,
symbol,
operate_op,
operate_name,
operate_date,
accept_op,
accept_name,
accept_date,
grade,
idea,
product_model,
valid_date_start,
'',--新字段
hid,
history_op,
history_name,
history_date,
his_type
from bemms.t_evaluation_grade_his;
--将老表重命名为任意名称
alter table t_evaluation_grade_his rename to t_evaluation_grade_his_invalid;
--将新表名称重命名为正式表名
alter table t_evaluation_grade_his1 rename to t_evaluation_grade_his;
--删掉作废的老表
drop table t_evaluation_grade_his_invalid;