Syntax should be:

alter table tst rename column c1 to c2;

Hans

-----Original Message-----
From: Liu Sherry
[mailto:oracledba-ezmlmshield-x11302792.[Email address protected]
Sent: woensdag 29 maart 2006 20:15
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
-----------------------------------------------------------------
ATTENTION:
The information in this electronic mail message is private and
confidential, and only intended for the addressee. Should you
receive this message by mistake, you are hereby notified that
any disclosure, reproduction, distribution or use of this
message is strictly prohibited. Please inform the sender by
reply transmission and delete the message without copying or
opening it.

Messages and attachments are scanned for all viruses known.
If this message contains password-protected attachments, the
files have NOT been scanned for viruses by the ING mail domain.
Always scan attachments before opening them.
-----------------------------------------------------------------


Oracle LazyDBA home page