通过数据字典修改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
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