Restrictions on the rename_column_clause: ========================================= + You cannot combine this clause with any of the other column_clauses in the same statement. + You cannot rename a column that is used to define a join index. Instead you must drop the index, rename the column, and re-create the index.
SQL> alter table test rename lognum to logid; alter table test rename lognum to logid * ERROR 位于第 1 行: ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失 SQL> select * from v$version;BANNER ---------------------------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production 看看,9.2也不支持啊
========================================= + You cannot combine this clause with any of the other column_clauses in the
same statement. + You cannot rename a column that is used to define a join index. Instead you
must drop the index, rename the column, and re-create the index.
alter table test rename lognum to logid
*
ERROR 位于第 1 行:
ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失
SQL> select * from v$version;BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production
看看,9.2也不支持啊