DROP TABLE ERX.OUTBOUND_NCPDP_MSG_HIST CASCADE CONSTRAINTS ;

CREATE TABLE ERX.OUTBOUND_NCPDP_MSG_HIST
  (
    OUTBOUND_NCPDP_MSG_HIST_ID NUMBER NOT NULL ,
    OUTBOUND_NCPDP_MSG_ID      NUMBER NOT NULL ,
    MESSAGE_STATUS             VARCHAR2 (4)  ,   
    RUN_CNT					  NUMBER,
    UPDATED_DATE                DATE ,
    CREATED_DATE               DATE
  )
  LOGGING ;
CREATE UNIQUE INDEX ERX.OB_NCPDP_MSG_HIST_ID_IDX ON ERX.OUTBOUND_NCPDP_MSG_HIST
  (
    OUTBOUND_NCPDP_MSG_HIST_ID ASC
  )
  LOGGING ;
