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

Previous Topic: Need help on ALL/DBA_DEPENDENCIES
Next Topic: ERROR: ORA-01017
Goto Forum:

Current Time: Sat Aug 19 10:08:46 CDT 2017

Total time taken to generate the page: 0.01542 seconds