Home » SQL & PL/SQL » SQL & PL/SQL » ORA-14155 (oracle 10g)
ORA-14155 [message #332807] Wed, 09 July 2008 15:20 Go to next message
mary_xXx
Messages: 6
Registered: July 2008
Junior Member
Dear All,
I am trying to re-name a column I have in my table. I am using the following syntax to do so;
ALTER TABLE <table name> RENAME <old_column> TO <new_column>;

But doing so, I get the following error message;
ORA-14155: missing PARTITION or SUBPARTITION keyword

1) Could someone explain to me what the messages means by 'partition' and also
2) what is the correct way of changing a column name?

Thanks in advance
Mary
Re: ORA-14155 [message #332808 is a reply to message #332807] Wed, 09 July 2008 15:23 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Do you know what a partitioned table is?
Is the table involved a partitioned table?
Re: ORA-14155 [message #332809 is a reply to message #332807] Wed, 09 July 2008 15:26 Go to previous messageGo to next message
mary_xXx
Messages: 6
Registered: July 2008
Junior Member
hey,
i do not know what a partition table
its a very simple table that was created using standard create table syntax!!
Re: ORA-14155 [message #332816 is a reply to message #332809] Wed, 09 July 2008 15:49 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It usually helps if you use the correct syntax.
SQL> desc test
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------

 ID                                                 NUMBER
 NAME                                               VARCHAR2(20)

SQL> alter table test rename name to ime;
alter table test rename name to ime
                        *
ERROR at line 1:
ORA-14155: missing PARTITION or SUBPARTITION keyword


SQL> alter table test rename column name to ime;

Table altered.

SQL>
Re: ORA-14155 [message #332817 is a reply to message #332807] Wed, 09 July 2008 15:52 Go to previous message
mary_xXx
Messages: 6
Registered: July 2008
Junior Member
Thank You Very Much Smile
Previous Topic: Tables and Columns
Next Topic: Difference on Delete
Goto Forum:
  


Current Time: Wed Dec 07 09:09:18 CST 2016

Total time taken to generate the page: 0.12920 seconds