CREATE TABLE "MOUSETRAP"."MST_DOX_STAGEME" 
   (	"FEED_SRC" VARCHAR2(4 CHAR) DEFAULT 'DOX' NOT NULL ENABLE, 
	"AGRMT_ID" NUMBER(20,0) NOT NULL ENABLE, 
	"NETTCOL_ID" VARCHAR2(50 CHAR) NOT NULL ENABLE, 
	"CRXM_ID" VARCHAR2(20 CHAR) NOT NULL ENABLE, 
	"COMP_CODE" NUMBER(20,0) NOT NULL ENABLE, 
	"CRXMCNTRY" VARCHAR2(10 CHAR) NOT NULL ENABLE, 
	"BRANCH_ID" VARCHAR2(10 CHAR) NOT NULL ENABLE, 
	"PRODUCT_ID" VARCHAR2(30 CHAR) NOT NULL ENABLE, 
	"DOX_TYPE" CHAR(1 BYTE) NOT NULL ENABLE, 
	"SOA_NM" VARCHAR2(256 CHAR), 
	"SETLMTCCY" VARCHAR2(1500 CHAR), 
	"AGMT_TYPE" VARCHAR2(256 CHAR), 
	"CP_BRANCH" VARCHAR2(20 CHAR), 
	"IFRS_NET_IND" VARCHAR2(10 CHAR), 
	"RELATIONSHIP_TYPE" VARCHAR2(50 CHAR), 
	"ETD_COLLATERAL_INDICATOR" VARCHAR2(14 CHAR), 
	"AGREEMENT_TEMPLATE" VARCHAR2(100 CHAR) DEFAULT NULL NOT NULL ENABLE, 
	"REMEDIATION_REG_TYPE" VARCHAR2(4 CHAR), 
	 CONSTRAINT "MST_DOX_STAGEME_PK" PRIMARY KEY ("FEED_SRC", "AGRMT_ID", "NETTCOL_ID", "CRXM_ID", "COMP_CODE", "CRXMCNTRY", "BRANCH_ID", "PRODUCT_ID", "DOX_TYPE", "CP_BRANCH", "IFRS_NET_IND", "RELATIONSHIP_TYPE", "AGREEMENT_TEMPLATE")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
  STORAGE(INITIAL 2097152 NEXT 2097152 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "MOUSETRAP_DATA"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS  LOGGING 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "MOUSETRAP_DATA" 
  PARTITION BY LIST ("FEED_SRC") 
 (PARTITION "DOX"  VALUES ('DOX') SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING 
  STORAGE(INITIAL 10485760 NEXT 10485760 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "MOUSETRAP_DATA" ) ;

SELECT * FROM dba_ind_partitions
where index_name='MST_DOX_STAGEME_PK'

SELECT status, partitioned FROM dba_indexes 
--WHERE partitioned = 'NO'
where index_name='MST_DSR_STAGEME_PK'

SELECT status, partitioned FROM dba_indexes 
--WHERE partitioned = 'NO'
where index_name='MST_DOX_STAGEME_PK'

ALTER INDEX MST_DOX_STAGEME_PK REBUILD PARTITION DOX TABLESPACE MOUSETRAP_DATA;