ORA-14255 Table is not Partitioned by Range,List

> A Table that Contains only One Partition Cannot be Dropped. You must drop the Table.


SQL> CREATE TABLE KKHASH
    (
    EMPNO NUMBER(5),
    ENAME VARCHAR2(5),
    LOCATION VARCHAR2(5))
    PARTITION BY HASH (LOCATION)
    (
    PARTITION H1 TABLESPACE USERS,
    PARTITION H2 TABLESPACE USERS
    );

Table created.


SQL> ALTER TABLE KKHASH DROP PARTITION H1;

         ERROR at line 1:

ORA-14255: table is not partitioned by Range, List, Composite Range or Composite List method


SQL> DROP TABLE KKHASH;
       
Table dropped.


Happy Learning...