Member Avatar for naser.ca

Hi,

I am using oracle 9i. I've got hard time rying to rename columns or constraint definition.

I use the following for renaming a column:

ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name;

but I get this error ORA-14155: missing PARTITION or SUBPARTITION keyword .

The same thing is experienced with the constraint case, however I have no problem in renaming a table itself.

Looking forward to a solution.

  • 4 Contributors
  • 3 Replies
  • 221 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for Sulley's Boo

From version 9i release 2 and on, the column renaming feature works.

Member Avatar for jwenting

I wonder why anyone would still use an unsupported version...

Member Avatar for debasisdas

That simply means you are not using the correct version or oracle database. You are trying to execute some advance commands in the un-supported earlier versions.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.