alter table tst rename column c1 to c2;

-----Original Message-----
From: Liu Sherry
[mailto:oracledba-ezmlmshield-x11302792.[Email address protected]
Sent: Wednesday, March 29, 2006 11:15 AM
To: LazyDBA Discussion
Subject: rename column name

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


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page