CREATE TABLE "XXX_OWNER"."SHOW_LOB_STORAGE" 
   (	"INTERCHANGEKEY" NUMBER(38,0) NOT NULL ENABLE, 
	"PURGEDATE" DATE NOT NULL ENABLE, 
	"ADDITIONALINFORMATION" CLOB
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "XXX_DATA" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  ENABLE STORAGE IN ROW CHUNK 8192
  CACHE  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) 
  PARTITION BY RANGE ("PURGEDATE") INTERVAL (NUMTODSINTERVAL('1', 'DAY')) 
  SUBPARTITION BY HASH ("INTERCHANGEKEY") 
  SUBPARTITIONS 16
 (PARTITION "PAYM_INTCHG_INIT_PART"  VALUES LESS THAN (TO_DATE(' 2017-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "XXX_DATA" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  ENABLE STORAGE IN ROW CHUNK 8192
  CACHE  NOCOMPRESS  KEEP_DUPLICATES 
  STORAGE(
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)) 
 ( SUBPARTITION "SYS_SUBP2116124" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 COLUMN STORE COMPRESS FOR ARCHIVE HIGH NO ROW LEVEL LOCKING , 
  SUBPARTITION "SYS_SUBP2116125" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116126" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116127" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116128" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116129" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116130" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116131" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116132" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116133" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116134" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116135" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116136" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116137" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116138" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS , 
  SUBPARTITION "SYS_SUBP2116139" 
 LOB ("ADDITIONALINFORMATION") STORE AS SECUREFILE (
  TABLESPACE "XXX_DATA" ) 
  TABLESPACE "XXX_DATA" 
 NOCOMPRESS ) )  ENABLE ROW MOVEMENT ;