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
Messages: 61
Registered: November 2006
I am using Oracle9i Enterprise Edition Release
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: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Renaming a column was introduced in 9.2.

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

Current Time: Sat Oct 22 12:00:39 CDT 2016

Total time taken to generate the page: 0.04900 seconds