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!

"ORA-14501: object is not part"How to add partition for the existing Table?

996900Aug 11 2012 — edited Aug 11 2012
It is Possible without droping the existng Table

alter table LIVECTYH10.CTYT_CTRN_H10 add partition
ctrn_201010 values less than (to_date('31-OCT-2010','DD-MON-YYYY'));

ORA-14501: object is not partitioned

Thanks

Edited by: Raj1985 on Aug 11, 2012 12:39 AM

Edited by: Raj1985 on Aug 11, 2012 12:44 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 8 2012
Added on Aug 11 2012
#oracle
3 comments
6,218 views