DROP INDEX PS_PSAPMSGPCONDATA / CREATE UNIQUE iNDEX PS_PSAPMSGPCONDATA ON PSAPMSGPCONDATA (PUBNODE, CHNLNAME, PUBID, SUBNODE, IB_SEGMENTINDEX, SEGMENTNO, SUBSEGMENTNO, DATASEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPCONDATA NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBCERRP / CREATE UNIQUE iNDEX PS_PSAPMSGPUBCERRP ON PSAPMSGPUBCERRP (PUBNODE, CHNLNAME, PUBID, SUBNODE, IB_SEGMENTINDEX, ERRORTIMESTAMP, SEQNO, PARM_SEQ) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBCERRP NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBCON / DROP INDEX PSAPSAPMSGPUBCON / DROP INDEX PSBPSAPMSGPUBCON / DROP INDEX PSCPSAPMSGPUBCON / CREATE UNIQUE iNDEX PS_PSAPMSGPUBCON ON PSAPMSGPUBCON (IBTRANSACTIONID, IB_SEGMENTINDEX, SUBNODE) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBCON NOPARALLEL LOGGING / CREATE INDEX PSAPSAPMSGPUBCON ON PSAPMSGPUBCON (QUEUENAME) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSAPSAPMSGPUBCON NOPARALLEL LOGGING / CREATE INDEX PSBPSAPMSGPUBCON ON PSAPMSGPUBCON (LASTUPDDTTM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSBPSAPMSGPUBCON NOPARALLEL LOGGING / CREATE INDEX PSCPSAPMSGPUBCON ON PSAPMSGPUBCON (PUBCONSTATUS, PUBLISHTIMESTAMP, SUBNODE) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSCPSAPMSGPUBCON NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBDATA / CREATE UNIQUE iNDEX PS_PSAPMSGPUBDATA ON PSAPMSGPUBDATA (IBTRANSACTIONID, IB_SEGMENTINDEX, SEGMENTNO, SUBSEGMENTNO, DATASEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBDATA NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBERR / CREATE UNIQUE iNDEX PS_PSAPMSGPUBERR ON PSAPMSGPUBERR (PUBNODE, CHNLNAME, PUBID, ERRORTIMESTAMP, SEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBERR NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBERRP / CREATE UNIQUE iNDEX PS_PSAPMSGPUBERRP ON PSAPMSGPUBERRP (PUBNODE, CHNLNAME, PUBID, ERRORTIMESTAMP, SEQNO, PARM_SEQ) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBERRP NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGPUBHDR / DROP INDEX PSAPSAPMSGPUBHDR / DROP INDEX PSBPSAPMSGPUBHDR / DROP INDEX PSCPSAPMSGPUBHDR / CREATE UNIQUE iNDEX PS_PSAPMSGPUBHDR ON PSAPMSGPUBHDR (IBTRANSACTIONID) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGPUBHDR NOPARALLEL LOGGING / CREATE INDEX PSAPSAPMSGPUBHDR ON PSAPMSGPUBHDR (QUEUENAME) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSAPSAPMSGPUBHDR NOPARALLEL LOGGING / CREATE INDEX PSBPSAPMSGPUBHDR ON PSAPMSGPUBHDR (LASTUPDDTTM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSBPSAPMSGPUBHDR NOPARALLEL LOGGING / CREATE INDEX PSCPSAPMSGPUBHDR ON PSAPMSGPUBHDR (PUBSTATUS, PUBLISHTIMESTAMP) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSCPSAPMSGPUBHDR NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGSCONDATA / CREATE UNIQUE iNDEX PS_PSAPMSGSCONDATA ON PSAPMSGSCONDATA (PUBNODE, CHNLNAME, PUBID, MSGNAME, SEGMENTNO, SUBSEGMENTNO, DATASEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGSCONDATA NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGSUBCERR / CREATE UNIQUE iNDEX PS_PSAPMSGSUBCERR ON PSAPMSGSUBCERR (PUBNODE, CHNLNAME, PUBID, MSGNAME, SUBNAME, IB_SEGMENTINDEX, ERRORTIMESTAMP, SEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGSUBCERR NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGSUBCERRP / CREATE UNIQUE iNDEX PS_PSAPMSGSUBCERRP ON PSAPMSGSUBCERRP (PUBNODE, CHNLNAME, PUBID, MSGNAME, SUBNAME, IB_SEGMENTINDEX, ERRORTIMESTAMP, SEQNO, PARM_SEQ) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGSUBCERRP NOPARALLEL LOGGING / DROP INDEX PS_PSAPMSGSUBCON / DROP INDEX PSAPSAPMSGSUBCON / DROP INDEX PSBPSAPMSGSUBCON / DROP INDEX PSCPSAPMSGSUBCON / CREATE UNIQUE iNDEX PS_PSAPMSGSUBCON ON PSAPMSGSUBCON (IBTRANSACTIONID, IB_SEGMENTINDEX, IB_OPERATIONNAME) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSAPMSGSUBCON NOPARALLEL LOGGING / CREATE INDEX PSAPSAPMSGSUBCON ON PSAPMSGSUBCON (QUEUENAME) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSAPSAPMSGSUBCON NOPARALLEL LOGGING / CREATE INDEX PSBPSAPMSGSUBCON ON PSAPMSGSUBCON (LASTUPDDTTM) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSBPSAPMSGSUBCON NOPARALLEL LOGGING / CREATE INDEX PSCPSAPMSGSUBCON ON PSAPMSGSUBCON (SUBCONSTATUS, PUBLISHTIMESTAMP) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PSCPSAPMSGSUBCON NOPARALLEL LOGGING / DROP INDEX PS_PSIBERR / CREATE UNIQUE iNDEX PS_PSIBERR ON PSIBERR (IBTRANSACTIONID, IB_SEGMENTINDEX, ERRORTIMESTAMP, SEQNO) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSIBERR NOPARALLEL LOGGING / DROP INDEX PS_PSIBERRP / CREATE UNIQUE iNDEX PS_PSIBERRP ON PSIBERRP (IBTRANSACTIONID, IB_SEGMENTINDEX, ERRORTIMESTAMP, SEQNO, PARM_SEQ) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSIBERRP NOPARALLEL LOGGING / DROP INDEX PS_PSIBLOGDATA / CREATE UNIQUE iNDEX PS_PSIBLOGDATA ON PSIBLOGDATA (GUID, DATASEQNO, LOGTYPE) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSIBLOGDATA NOPARALLEL LOGGING / DROP INDEX PS_PSIBLOGHDR / CREATE UNIQUE iNDEX PS_PSIBLOGHDR ON PSIBLOGHDR (GUID, IB_OPERATIONNAME, VERSIONNAME, TRXTYPE) TABLESPACE PSINDEX STORAGE (INITIAL 40000 NEXT 100000 MAXEXTENTS UNLIMITED PCTINCREASE 0) PCTFREE 10 PARALLEL NOLOGGING / ALTER INDEX PS_PSIBLOGHDR NOPARALLEL LOGGING /