Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename a column

kumar73Jan 24 2011 — edited Jan 24 2011
Hello Friends,

I am trying to rename a column by using the alter statement.

ALTER TABLE KAW_OWNER.X_HOUSEHOLD_UBS_DETAIL RENAME X_PEAK_12M_SEGMENT_CD TO X_PEAK_12M_SUBSEGMENT_CD ;



ORA-14155: missing PARTITION or SUBPARTITION keyword.

I checked the table script and there are no partitions and sub partitions.


Edited by: kumar73 on Jan 24, 2011 7:09 AM

Edited by: kumar73 on Jan 24, 2011 7:15 AM
This post has been answered by 792754 on Jan 24 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
2 comments
205 views