怎样在数据字典中直接修改Oracle表列名

　　SQL>CREATE TABLE SCOTT.TEST AS SELECT EMPNO,ENAME FROM SCOTT.EMP; 
　　
　　SQL>DESC SCOTT.TEST 
　　
　　Name Type Nullable Default Comments 
　　
　　------- ------------ ------- 
　　
　　EMPNO NUMBER(4) Y 
　　
　　ENAME VARCHAR2(10) Y

SQL>SET LONG 9999

SQL>SELECT TEXT FROM ALL_VIEWS 
WHERE VIEW_NAME = ‘USER_TAB_COLUMNS’;

SQL> SELECT * FROM ALL_OBJECTS WHERE OWNER =‘SCOTT’ 
    AND OBJECT_NAME=‘TEST’;

SQL> SELECT OBJ#,COL#,NAME FROM SYS.COL$ WHERE OBJ# =13888; 
OBJ# COL# NAME 
---------- ---------- ------- 
13888 1 EMPNO 
13888 2 ENAME

UPDATE SYS.COL$ SET COL# = 2,NAME=‘EMP_NO’ 
WHERE OBJ# = 13888 AND NAME=‘EMPNO’; 
UPDATE SYS.COL$ SET COL# = 1,NAME=‘EMP_NAME’ 
WHERE OBJ# = 13888 AND NAME =‘ENAME’; 
COMMIT;