CREATE TABLE NIMS.DB_FILES ( FILE_NAME VARCHAR2(255 BYTE) NOT NULL, DIR_NUM NUMBER(10), ORIGINAL_PATH VARCHAR2(255 BYTE), ORIGINAL_NAME VARCHAR2(255 BYTE), CHANGED_BY VARCHAR2(10 BYTE), CHANGED_ON DATE, LAST_MODIFIED DATE, FILE_SIZE NUMBER(10), FILE_CONTENTS BLOB, DESCRIPTION VARCHAR2(50 BYTE), GROUP_NAME VARCHAR2(10 BYTE), COMPUTER_NAME VARCHAR2(50 BYTE), HASH VARCHAR2(50 BYTE), FILE_LABEL VARCHAR2(100 BYTE), POSTED VARCHAR2(1 BYTE), INSTRUMENT VARCHAR2(30 BYTE), SUPPLEMENTAL LOG DATA (ALL) COLUMNS ) LOB (FILE_CONTENTS) STORE AS BASICFILE FILE_CONTENTS_STORE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS PCTUSED 0 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ) PARTITION BY RANGE (CHANGED_ON) INTERVAL( NUMTOYMINTERVAL(3,'MONTH')) ( PARTITION DBF_QTR_4_2007 VALUES LESS THAN (TO_DATE(' 2007-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2008 VALUES LESS THAN (TO_DATE(' 2008-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2008 VALUES LESS THAN (TO_DATE(' 2008-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2008 VALUES LESS THAN (TO_DATE(' 2008-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2008 VALUES LESS THAN (TO_DATE(' 2008-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2009 VALUES LESS THAN (TO_DATE(' 2009-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2009 VALUES LESS THAN (TO_DATE(' 2009-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2009 VALUES LESS THAN (TO_DATE(' 2009-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2009 VALUES LESS THAN (TO_DATE(' 2009-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2010 VALUES LESS THAN (TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2010 VALUES LESS THAN (TO_DATE(' 2010-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2010 VALUES LESS THAN (TO_DATE(' 2010-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2010 VALUES LESS THAN (TO_DATE(' 2010-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2011 VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2011 VALUES LESS THAN (TO_DATE(' 2011-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2011 VALUES LESS THAN (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2011 VALUES LESS THAN (TO_DATE(' 2011-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2012 VALUES LESS THAN (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2012 VALUES LESS THAN (TO_DATE(' 2012-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2012 VALUES LESS THAN (TO_DATE(' 2012-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2012 VALUES LESS THAN (TO_DATE(' 2012-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2013 VALUES LESS THAN (TO_DATE(' 2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2013 VALUES LESS THAN (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2013 VALUES LESS THAN (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2013 VALUES LESS THAN (TO_DATE(' 2013-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2014 VALUES LESS THAN (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2014 VALUES LESS THAN (TO_DATE(' 2014-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2014 VALUES LESS THAN (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2014 VALUES LESS THAN (TO_DATE(' 2014-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2015 VALUES LESS THAN (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2015 VALUES LESS THAN (TO_DATE(' 2015-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2015 VALUES LESS THAN (TO_DATE(' 2015-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2015 VALUES LESS THAN (TO_DATE(' 2015-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2016 VALUES LESS THAN (TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2016 VALUES LESS THAN (TO_DATE(' 2016-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2016 VALUES LESS THAN (TO_DATE(' 2016-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2016 VALUES LESS THAN (TO_DATE(' 2016-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2017 VALUES LESS THAN (TO_DATE(' 2017-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2017 VALUES LESS THAN (TO_DATE(' 2017-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2017 VALUES LESS THAN (TO_DATE(' 2017-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2017 VALUES LESS THAN (TO_DATE(' 2017-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2018 VALUES LESS THAN (TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2018 VALUES LESS THAN (TO_DATE(' 2018-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2018 VALUES LESS THAN (TO_DATE(' 2018-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2018 VALUES LESS THAN (TO_DATE(' 2018-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2019 VALUES LESS THAN (TO_DATE(' 2019-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2019 VALUES LESS THAN (TO_DATE(' 2019-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2019 VALUES LESS THAN (TO_DATE(' 2019-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2019 VALUES LESS THAN (TO_DATE(' 2019-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2020 VALUES LESS THAN (TO_DATE(' 2020-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2020 VALUES LESS THAN (TO_DATE(' 2020-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2020 VALUES LESS THAN (TO_DATE(' 2020-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2020 VALUES LESS THAN (TO_DATE(' 2020-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2021-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2021-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2021-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2021-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2022-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2022-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2022-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2022-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2023-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2023-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2023-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2023-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2024-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2024-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2024-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2024-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2025-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2025-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2025-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2025-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS BASICFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION VALUES LESS THAN (TO_DATE(' 2026-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) LOGGING NOCOMPRESS TABLESPACE NIMS_STATIC_SMALL_TS LOB (FILE_CONTENTS) STORE AS SECUREFILE ( TABLESPACE NIMS_DYNAMIC_LARGE_DATA_TS ENABLE STORAGE IN ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )) PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 8M NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ) ) NOCACHE MONITORING; CREATE INDEX NIMS.DB_FILES_DIR_13877 ON NIMS.DB_FILES (DIR_NUM) TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ) LOCAL ( PARTITION DBF_QTR_4_2007 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ) ); CREATE INDEX NIMS.IDX_DB_FILES_DIR ON NIMS.DB_FILES (CHANGED_ON) TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ) LOCAL ( PARTITION DBF_QTR_4_2007 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2008 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2009 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2010 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2011 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2012 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2013 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2014 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2015 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2016 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2017 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2018 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2019 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_1_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_2_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_3_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION DBF_QTR_4_2020 LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ), PARTITION LOGGING NOCOMPRESS TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED BUFFER_POOL DEFAULT ) ); -- There is no statement for index NIMS.SYS_C008208. -- The object is created when the parent object is created. ALTER TABLE NIMS.DB_FILES ADD ( PRIMARY KEY (FILE_NAME) USING INDEX TABLESPACE NIMS_DYNAMIC_LARGE_IDX_TS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ) ENABLE VALIDATE); GRANT SELECT ON NIMS.DB_FILES TO APPDDBMON; GRANT SELECT ON NIMS.DB_FILES TO NIMS_READONLY_ROLE; GRANT SELECT ON NIMS.DB_FILES TO READ_ONLY_NIMS;