OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-14155 (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-14155 [message #332807]

Wed, 09 July 2008 15:20

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

Report message to a moderator

Re: ORA-14155 [message #332808 is a reply to message #332807]

Wed, 09 July 2008 15:23

BlackSwan
Messages: 26766
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?

Report message to a moderator

Re: ORA-14155 [message #332809 is a reply to message #332807]

Wed, 09 July 2008 15:26

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!!

Report message to a moderator

Re: ORA-14155 [message #332816 is a reply to message #332809]

Wed, 09 July 2008 15:49

Littlefoot
Messages: 21808
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>

Report message to a moderator