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
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: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Renaming a column was introduced in 9.2.

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


Current Time: Mon Dec 05 04:52:07 CST 2016

Total time taken to generate the page: 0.06995 seconds