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