Oracle Database Discussions

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

152933May 29 2004 — edited May 29 2004

Hi
I have a table with hash partition .When i trying to drop one of the partition it giving the below error

What is diffrence between range and list oartition

SQL> ALTER TABLE EMP_H DROP PARTITION P3;
ALTER TABLE EMP_H DROP PARTITION P3
*
ERROR at line 1:
ORA-14255: table is not partitioned by Range, Composite Range or List method

Regards
Mohan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2004

Added on May 29 2004

#general-database-discussions

2 comments

1,346 views