用PL/SQL Developer 操作oracle报“ora-14155: partition或subpartition 关键字丢失”错误问题

来源：百度知道 编辑：UC知道 时间：2024/04/29 08:59:08
用PL/SQL Developer 操作oracle报“ora-14155: partition或subpartition 关键字丢失”错误问题。
oracle version 9i
pl/sql developer version 7.1.4.1390
OS XP
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production

8i的不行，可我这是9i怎么也没行呢？

abc@ABC> 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

abc@ABC> alter table a rename column id to id1;

表已更改。

此外确实8I的不行用RENAME

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
PL/SQL Release 8.1.7.0.0 - Production
CORE 8.1.7.0.0 Production

TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL> create table a(id int);

Table created

SQL> alter table a rename column id to