通过数据字典修改oracle字段顺序

SELECT T.OBJ#, T.COL#, T.NAME, T.ROWID
  FROM SYS.COL$ T
  JOIN ALL_OBJECTS A
    ON A.OBJECT_ID = OBJ#
 WHERE A.OWNER = 'NGMESUSER'
   AND A.OBJECT_NAME = 'TB_FACTORY';

拿sys登录,修改col顺序。
重启数据库服务,使生效:
SQL>SHUTDOWN
SQL>STARTUP

 

原文地址:https://www.cnblogs.com/zhahost/p/3091042.html