用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怎么也没行呢？
最新回答
伤丶始终落疤
2024-04-30 05:18:21
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 id1;
alter table a rename column id to id1
ORA-14155: PARTITION 或 SUBPARTITION 关键字丢失
热门标签
