Renaming columns or constraints in Oracle 9i

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,575 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,459 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 984 | Replies: 3

•

Join Date: Oct 2006

Posts: 1

Reputation: naser.ca is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

naser.ca

Offline

Newbie Poster

Renaming columns or constraints in Oracle 9i

Apr 6th, 2008

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:

Help with Code Tags

(Toggle Plain Text)

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.

•

Join Date: Dec 2004

Location: UAE

Posts: 406

Reputation: Sulley's Boo will become famous soon enough

Rep Power: 5

Solved Threads: 9

Sulley's Boo Sulley's Boo is offline

Offline

Posting Pro in Training

Re: Renaming columns or constraints in Oracle 9i

Apr 7th, 2008

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

•

Join Date: Nov 2004

Location: Netherlands

Posts: 5,752

Reputation: jwenting is a jewel in the rough

Rep Power: 18

Solved Threads: 197

jwenting

Offline

duckman

Re: Renaming columns or constraints in Oracle 9i

Apr 7th, 2008

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

As people are clearly allowed to attack me but I'm not allowed to defend myself, I no longer post to this site.

•

Join Date: Feb 2007

Location: Bangalore,India

Posts: 1,270

Reputation: debasisdas is on a distinguished road

Rep Power: 4

Solved Threads: 80

debasisdas debasisdas is offline

Offline

Nearly a Posting Virtuoso

Re: Renaming columns or constraints in Oracle 9i

Apr 8th, 2008

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.

Share your Knowledge.