ALTER TABLE ESRJMS.MS9JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS9JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS9JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS9_JMSSTORE_X ON ESRJMS.MS9JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS9JMSSTORE ADD (
  CONSTRAINT MS9_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS9_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS9JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS9JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS9JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS9JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS9_JMSSTATE_X ON ESRJMS.MS9JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS9JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS9JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS8JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS8JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS8JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS8_JMSSTORE_X ON ESRJMS.MS8JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS8JMSSTORE ADD (
  CONSTRAINT MS8_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS8_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS8JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS8JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS8JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS8JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS8_JMSSTATE_X ON ESRJMS.MS8JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS8JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS8JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS7JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS7JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS7JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS7_JMSSTORE_X ON ESRJMS.MS7JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS7JMSSTORE ADD (
  CONSTRAINT MS7_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS7_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS7JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS7JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS7JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS7JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS7_JMSSTATE_X ON ESRJMS.MS7JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS7JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS7JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS6JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS6JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS6JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS6_JMSSTORE_X ON ESRJMS.MS6JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS6JMSSTORE ADD (
  CONSTRAINT MS6_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS6_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS6JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS6JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS6JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS6JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS6_JMSSTATE_X ON ESRJMS.MS6JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS6JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS6JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS5JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS5JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS5JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS5_JMSSTORE_X ON ESRJMS.MS5JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS5JMSSTORE ADD (
  CONSTRAINT MS5_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS5_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS5JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS5JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS5JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS5JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS5_JMSSTATE_X ON ESRJMS.MS5JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS5JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS5JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS4JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS4JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS4JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS4_JMSSTORE_X ON ESRJMS.MS4JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS4JMSSTORE ADD (
  CONSTRAINT MS4_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS4_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS4JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS4JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS4JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS4JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS4_JMSSTATE_X ON ESRJMS.MS4JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS4JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS4JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS3JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS3JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS3JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS3_JMSSTORE_X ON ESRJMS.MS3JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS3JMSSTORE ADD (
  CONSTRAINT MS3_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS3_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS3JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS3JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS3JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS3JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS3_JMSSTATE_X ON ESRJMS.MS3JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS3JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS3JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS2JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS2JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS2JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS2_JMSSTORE_X ON ESRJMS.MS2JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS2JMSSTORE ADD (
  CONSTRAINT MS2_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS2_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS2JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS2JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS2JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS2JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS2_JMSSTATE_X ON ESRJMS.MS2JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS2JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS2JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS1JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS1JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS1JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS1_JMSSTORE_X ON ESRJMS.MS1JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS1JMSSTORE ADD (
  CONSTRAINT MS1_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS1_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS1JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS1JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS1JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS1JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS1_JMSSTATE_X ON ESRJMS.MS1JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS1JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS1JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS15WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS15WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS15WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189545.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS15WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS15WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS15WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS15JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS15JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS15JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS15_JMSSTORE_X ON ESRJMS.MS15JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS15JMSSTORE ADD (
  CONSTRAINT MS15_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS15_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS15JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS15JMSSTORE TO ESRJMS_RW;

GRANT SELECT ON ESRJMS.MS15JMSSTORE TO ISCOPE_ORCL;
DROP TABLE ESRJMS.MS15JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS15JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS15_JMSSTATE_X ON ESRJMS.MS15JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS15JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS15JMSSTATE TO ESRJMS_RW;

GRANT SELECT ON ESRJMS.MS15JMSSTATE TO ISCOPE_ORCL;
ALTER TABLE ESRJMS.MS14WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS14WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS14WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189250.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS14WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS14WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS14WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS14JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS14JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS14JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS14_JMSSTORE_X ON ESRJMS.MS14JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS14JMSSTORE ADD (
  CONSTRAINT MS14_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS14_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS14JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS14JMSSTORE TO ESRJMS_RW;

GRANT SELECT ON ESRJMS.MS14JMSSTORE TO ISCOPE_ORCL;
DROP TABLE ESRJMS.MS14JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS14JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS14_JMSSTATE_X ON ESRJMS.MS14JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS14JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS14JMSSTATE TO ESRJMS_RW;

GRANT SELECT ON ESRJMS.MS14JMSSTATE TO ISCOPE_ORCL;
ALTER TABLE ESRJMS.MS13WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS13WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS13WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189295.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS13WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS13WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS13WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS13JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS13JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS13JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS13_JMSSTORE_X ON ESRJMS.MS13JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS13JMSSTORE ADD (
  CONSTRAINT MS13_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS13_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS13JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS13JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS13JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS13JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS13_JMSSTATE_X ON ESRJMS.MS13JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          4M
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS13JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS13JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS12WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS12WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS12WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189290.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS12WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS12WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS12WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS12JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS12JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS12JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS12_JMSSTORE_X ON ESRJMS.MS12JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS12JMSSTORE ADD (
  CONSTRAINT MS12_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS12_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS12JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS12JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS12JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS12JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS12_JMSSTATE_X ON ESRJMS.MS12JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS12JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS12JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS11WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS11WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS11WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189550.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS11WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS11WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS11WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS11JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS11JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS11JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS11_JMSSTORE_X ON ESRJMS.MS11JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS11JMSSTORE ADD (
  CONSTRAINT MS11_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS11_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS11JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS11JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS11JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS11JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS11_JMSSTATE_X ON ESRJMS.MS11JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS11JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS11JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS10WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS10WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS10WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189260.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS10WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS10WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS10WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS10JMSSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS10JMSSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS10JMSSTORE
(
  RECORDHANDLE  INTEGER                         NOT NULL,
  RECORDSTATE   INTEGER,
  RECORD        LONG RAW
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE UNIQUE INDEX ESRJMS.MS10_JMSSTORE_X ON ESRJMS.MS10JMSSTORE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

ALTER TABLE ESRJMS.MS10JMSSTORE ADD (
  CONSTRAINT MS10_JMSSTORE_X
  PRIMARY KEY
  (RECORDHANDLE)
  USING INDEX ESRJMS.MS10_JMSSTORE_X
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS10JMSSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS10JMSSTORE TO ESRJMS_RW;
DROP TABLE ESRJMS.MS10JMSSTATE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS10JMSSTATE
(
  RECORDHANDLE      INTEGER,
  RECORDSTATE       INTEGER,
  RECORDGENERATION  INTEGER
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


CREATE INDEX ESRJMS.MS10_JMSSTATE_X ON ESRJMS.MS10JMSSTATE
(RECORDHANDLE)
LOGGING
TABLESPACE S_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;

GRANT SELECT ON ESRJMS.MS10JMSSTATE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS10JMSSTATE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS09WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS09WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS09WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189245.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS09WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS09WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS09WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS08WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS08WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS08WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189265.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS08WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS08WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS08WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS07WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS07WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS07WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189275.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS07WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS07WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS07WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS06WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS06WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS06WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189270.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS06WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS06WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS06WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS05WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS05WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS05WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189255.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS05WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS05WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS05WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS04WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS04WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS04WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189280.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS04WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS04WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS04WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS03WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS03WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS03WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00189285.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS03WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS03WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS03WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS02WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS02WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS02WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00188828.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS02WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS02WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS02WLSTORE TO ESRJMS_RW;
ALTER TABLE ESRJMS.MS01WLSTORE
 DROP PRIMARY KEY CASCADE;

DROP TABLE ESRJMS.MS01WLSTORE CASCADE CONSTRAINTS;

CREATE TABLE ESRJMS.MS01WLSTORE
(
  ID      INTEGER                               NOT NULL,
  TYPE    INTEGER                               NOT NULL,
  HANDLE  INTEGER                               NOT NULL,
  RECORD  LONG RAW                              NOT NULL
)
TABLESPACE S_DATA_01
RESULT_CACHE (MODE DEFAULT)
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          128K
            NEXT             128K
            MAXSIZE          UNLIMITED
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
LOGGING 
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING;


--  There is no statement for index ESRJMS.SYS_C00188823.
--  The object is created when the parent object is created.

ALTER TABLE ESRJMS.MS01WLSTORE ADD (
  PRIMARY KEY
  (ID)
  USING INDEX
    TABLESPACE S_INDEX_01
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          128K
                NEXT             128K
                MAXSIZE          UNLIMITED
                MINEXTENTS       1
                MAXEXTENTS       UNLIMITED
                PCTINCREASE      0
                BUFFER_POOL      DEFAULT
                FLASH_CACHE      DEFAULT
                CELL_FLASH_CACHE DEFAULT
               )
  ENABLE VALIDATE);

GRANT SELECT ON ESRJMS.MS01WLSTORE TO ESRJMS_R;

GRANT DELETE, INSERT, SELECT, UPDATE ON ESRJMS.MS01WLSTORE TO ESRJMS_RW;
