SQL> select * from user_part_indexes;
INDEX_NAME TABLE_NAME PARTITIONING_TYPE SUBPARTITIONING_TYPE PARTITION_COUNT DEF_SUBPARTITION_COUNT PARTITIONING_KEY_COUNT SUBPARTITIONING_KEY_COUNT LOCALITY ALIGNMENT DEF_TABLESPACE_NAME DEF_PCT_FREE DEF_INI_TRANS DEF_MAX_TRANS DEF_INITIAL_EXTENT DEF_NEXT_EXTENT DEF_MIN_EXTENTS DEF_MAX_EXTENTS DEF_MAX_SIZE DEF_PCT_INCREASE DEF_FREELISTS DEF_FREELIST_GROUPS DEF_LOGGING DEF_BUFFER_POOL DEF_FLASH_CACHE DEF_CELL_FLASH_CACHE DEF_PARAMETERS INTERVAL
------------------------------ ------------------------------ ----------------- -------------------- --------------- ---------------------- ---------------------- ------------------------- -------- ------------ ------------------------------ ------------ ------------- ------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- ------------- ------------------- ----------- --------------- --------------- -------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
SYS_IL0000089858C00004$$ ESB2_TRANS_LOG_MSG RANGE NONE 10 0 1 0 LOCAL NON_PREFIXED 10 1 255 DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT 0 0 NONE DEFAULT DEFAULT DEFAULT
IDX_ESB2_TRANS_LOG_MSG ESB2_TRANS_LOG_MSG RANGE NONE 10 0 1 0 LOCAL NON_PREFIXED 10 2 255 DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT 0 0 NONE DEFAULT DEFAULT DEFAULT
IDX1_ESB2_TRANS_LOG ESB2_TRANS_LOG RANGE NONE 9 0 1 0 LOCAL NON_PREFIXED 10 2 255 DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT DEFAULT 0 0 NONE DEFAULT DEFAULT DEFAULT
SQL>
SQL>
SQL> select * from user_ind_partitions a where a.index_name='IDX1_ESB2_TRANS_LOG';
INDEX_NAME COMPOSITE PARTITION_NAME SUBPARTITION_COUNT HIGH_VALUE HIGH_VALUE_LENGTH PARTITION_POSITION STATUS TABLESPACE_NAME PCT_FREE INI_TRANS MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENT MAX_EXTENT MAX_SIZE PCT_INCREASE FREELISTS FREELIST_GROUPS LOGGING COMPRESSION BLEVEL LEAF_BLOCKS DISTINCT_KEYS AVG_LEAF_BLOCKS_PER_KEY AVG_DATA_BLOCKS_PER_KEY CLUSTERING_FACTOR NUM_ROWS SAMPLE_SIZE LAST_ANALYZED BUFFER_POOL FLASH_CACHE CELL_FLASH_CACHE USER_STATS PCT_DIRECT_ACCESS GLOBAL_STATS DOMIDX_OPSTATUS PARAMETERS INTERVAL SEGMENT_CREATED
------------------------------ --------- ------------------------------ ------------------ -------------------------------------------------------------------------------- ----------------- ------------------ -------- ------------------------------ ---------- ---------- ---------- -------------- ----------- ---------- ---------- ---------- ------------ ---------- --------------- ------- ----------- ---------- ----------- ------------- ----------------------- ----------------------- ----------------- ---------- ----------- ------------- ----------- ----------- ---------------- ---------- ----------------- ------------ --------------- -------------------------------------------------------------------------------- -------- ---------------
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181129 0 TO_DATE(' 2018-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 1 USABLE ESBTRANS01_DATA_TBS_01 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 332170 11018601 1 1 10393665 21966202 69502 2018/11/29 22 DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181130 0 TO_DATE(' 2018-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 2 USABLE ESBTRANS02_DATA_TBS_02 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 395166 13073048 1 1 12504929 26198088 76705 2018/11/30 22 DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181201 0 TO_DATE(' 2018-12-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 3 USABLE ESBTRANS03_DATA_TBS_03 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 210168 6953323 1 1 5742661 13883151 72333 2018/12/1 22: DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181202 0 TO_DATE(' 2018-12-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 4 USABLE ESBTRANS04_DATA_TBS_04 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 183049 6028668 1 1 4903103 11837562 72429 2018/12/2 22: DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181203 0 TO_DATE(' 2018-12-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 5 USABLE ESBTRANS05_DATA_TBS_05 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 386752 12797561 1 1 12383355 25952612 74888 2018/12/3 22: DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181204 0 TO_DATE(' 2018-12-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 6 USABLE ESBTRANS06_DATA_TBS_06 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 363219 12137813 1 1 11567670 23994408 75441 2018/12/4 22: DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181205 0 TO_DATE(' 2018-12-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 7 USABLE ESBTRANS07_DATA_TBS_07 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED 3 371718 12094325 1 1 11492845 25229445 78800 2018/12/5 22: DEFAULT DEFAULT DEFAULT NO YES NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_181207 0 TO_DATE(' 2018-12-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 8 USABLE ESBTRANS08_DATA_TBS_08 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED DEFAULT DEFAULT DEFAULT NO NO NO YES
IDX1_ESB2_TRANS_LOG NO ESB2_TRANS_LOG_REMINDER 0 TO_DATE(' 2999-12-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA 83 9 USABLE REMINDER_DATA_TBS_01 10 2 255 65536 1048576 1 2147483645 2147483645 YES DISABLED DEFAULT DEFAULT DEFAULT NO NO NO YES
9 rows selected
SQL>