oracle 调整表字段顺序

--将想调整后的顺序新建一张表
-- 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;