I am in 9i R2, but I cannot change column name, have any idea?



Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> create table tst (c1 number);

Table created.

SQL> alter table tst rename c1 to c2;
alter table tst rename c1 to c2
*
ERROR at line 1:
ORA-14155: missing PARTITION or SUBPARTITION keyword

Oracle LazyDBA home page