SQL> select index_name,index_type ,table_name from dba_indexes where owner='BPMDATAPREPRODMU';
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000254531C00102$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00101$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00100$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00099$$ LOB MU_CUSTOMER_ONBOARDING
IDX_COB_NIND_MASTER_BK NORMA MU_COB_NIND_MASTER
L
IDX_COB_NIND_DETAILS_BK NORMA MU_COB_NIND_DETAILS
L
SYS_IL0000254567C00010$$ LOB MU_ERROR_LOG
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000254577C00014$$ LOB MU_REQUEST_LOG
SYS_IL0000254581C00010$$ LOB MU_RESPONSE_LOG
SYS_IL0000368559C00050$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368559C00047$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368559C00046$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368559C00045$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368559C00044$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368559C00030$$ LOB MU_COB_NIND_MASTER
SYS_IL0000368573C00136$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00141$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00142$$ LOB MU_COB_NIND_DETAILS
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000368573C00152$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00154$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00155$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00157$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00158$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00159$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00160$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00161$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00162$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00163$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00166$$ LOB MU_COB_NIND_DETAILS
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000368573C00167$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000300873C00102$$ LOB MU_DOCUMENT_CAPTURE
SYS_IL0000300873C00100$$ LOB MU_DOCUMENT_CAPTURE
BU_CODE_I NORMA MU_DOCUMENT_CAPTURE
L
SYS_IL0000324112C00018$$ LOB MU_DC_ATTACHMENTS
SYS_IL0000324112C00005$$ LOB MU_DC_ATTACHMENTS
SYS_IL0000324118C00010$$ LOB MU_DC_INTERFACE
SYS_IL0000324118C00002$$ LOB MU_DC_INTERFACE
SYS_IL0000254521C00018$$ LOB MU_ATTACHMENTS
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000254521C00005$$ LOB MU_ATTACHMENTS
SYS_IL0000254527C00005$$ LOB MU_COMMENTS
SYS_IL0000254531C00096$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00095$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00094$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00081$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00075$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00074$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00073$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00072$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00069$$ LOB MU_CUSTOMER_ONBOARDING
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000254531C00068$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00067$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00066$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00065$$ LOB MU_CUSTOMER_ONBOARDING
LOOKUP_ID_PK NORMA MU_LOOKUPS
L
SYS_IL0000368648C00005$$ LOB MU_CBS_PARAM_RECORDS
SYS_IL0000368573C00019$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00030$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00034$$ LOB MU_COB_NIND_DETAILS
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000368573C00035$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00045$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00050$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00063$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00064$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00071$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00084$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00085$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00087$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00094$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00099$$ LOB MU_COB_NIND_DETAILS
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000368573C00100$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00101$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00102$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00103$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00115$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00116$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00118$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00170$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000368573C00168$$ LOB MU_COB_NIND_DETAILS
SYS_IL0000254531C00105$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00106$$ LOB MU_CUSTOMER_ONBOARDING
INDEX_NAME INDEX TABLE_NAME
------------------------------ ----- ------------------------------
SYS_IL0000254531C00107$$ LOB MU_CUSTOMER_ONBOARDING
SYS_IL0000254531C00109$$ LOB MU_CUSTOMER_ONBOARDING
82 rows selected.