Home » SQL & PL/SQL » SQL & PL/SQL » unable to rename column
unable to rename column [message #236641] Thu, 10 May 2007 08:10 Go to next message
kanis
Messages: 61
Registered: November 2006
Member
Hi
I am using Oracle9i Enterprise Edition Release 9.0.1.1.1.
I am trying to rename a column of table using query
"alter table dept rename column dname to pname".
m getting following error
"ORA-14155: missing PARTITION or SUBPARTITION keyword "

Can any one help me out.
Thanks in advance Razz

Report message to a moderator

Re: unable to rename column [message #236646 is a reply to message #236641] Thu, 10 May 2007 08:33 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Renaming a column was introduced in 9.2.

Regards
Michel

Report message to a moderator

Previous Topic: how to retrive last five records from table
Next Topic: Replication, Streams, Merge or MVs?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 19:15:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.