Create LIST PARTITION table

CREATE TABLE list_part
(
    SUM_STATUS_CD               VARCHAR2(1 CHAR)  NOT NULL ,
    LAST_UPDT_TS                TIMESTAMP  NOT NULL ,
    LAST_UPDT_USER_ID           VARCHAR2(40 CHAR)  NOT NULL
)
    PARTITION BY LIST( sum_status_cd )
     (PARTITION status_unprocess VALUES('U'),
      PARTITION status_processed VALUES('P'))
    ENABLE ROW MOVEMENT 
    TABLESPACE DATA01;


SELECT count(*) 

FROM DATA_INTRCHNG_SUM_QUEUE 

PARTITION(status_unprocess);