oracle 表结构字段位置更改
2019-03-26 本文已影响0人
小冕
用sys用户登录执行以下命令：
select object_id from all_objects where object_name='TEST';
select object_id from obj where object_name='TEST';取得表TEST的object_id;假设为51234
select obj#,col#,name from sys.col set col#=1 where obj#=51234 and name='COL4';
update sys.col$ set col#=col#+1 where obj#=51234 and name!='COL4';
COMMIT;
SHUTDOWN IMMEDIATE;
STARTUP;
参考https://blog.csdn.net/mxw976235955/article/details/75269138
