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

发布网友发布时间：2022-04-13 16:32

共1个回答

热心网友时间：2022-04-13 18:01

abc@ABC> select * from v$VERSION;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Proction
PL/SQL Release 9.2.0.1.0 - Proction
CORE 9.2.0.1.0 Proction
TNS for 32-bit Windows: Version 9.2.0.1.0 - Proction
NLSRTL Version 9.2.0.1.0 - Proction

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 - Proction
PL/SQL Release 8.1.7.0.0 - Proction
CORE 8.1.7.0.0 Proction

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

SQL> create table a(id int);

Table created

SQL> alter table a rename column id to id1;

alter table a rename column id to id1

ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失

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

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