VIEW: SYS.UTL_ALL_IND_COMPS

Source

View Text - Preformatted

SELECT "CTYPE","INDEX_NAME","COMPONENT_NAME","TABLE_ID","TAB_OWNER_ID","IDX_ID","IND_OWNER_ID","IND_OWNER_NAME","COMP_ID","TCOMP_ID","CCOMP_ID","TCCOMP_ID","STATUS","LOCALITY","DEGREE","ROWCNT","JOIN_INDEX" FROM "_utl$_gnp_ind" WHERE (tab_owner_id = userenv('SCHEMAID')
       OR ind_owner_id = userenv('SCHEMAID')
       OR EXISTS (SELECT NULL FROM sys.v$enabledprivs
                  WHERE priv_number in (-72 /* ALTER ANY INDEX */,
                                        -42 /* ALTER ANY TABLE */)))
UNION ALL
SELECT "CTYPE","INDEX_NAME","COMPONENT_NAME","TABLE_ID","TAB_OWNER_ID","IDX_ID","IND_OWNER_ID","IND_OWNER_NAME","COMP_ID","TCOMP_ID","CCOMP_ID","TCCOMP_ID","STATUS","LOCALITY","DEGREE","ROWCNT","JOIN_INDEX" FROM "_utl$_gp_ind_parts" WHERE (tab_owner_id = userenv('SCHEMAID')
       OR ind_owner_id = userenv('SCHEMAID')
       OR EXISTS (SELECT NULL FROM sys.v$enabledprivs
                  WHERE priv_number in (-72 /* ALTER ANY INDEX */,
                                        -42 /* ALTER ANY TABLE */)))
UNION ALL
SELECT "CTYPE","INDEX_NAME","COMPONENT_NAME","TABLE_ID","TAB_OWNER_ID","IDX_ID","IND_OWNER_ID","IND_OWNER_NAME","COMP_ID","TCOMP_ID","CCOMP_ID","TCCOMP_ID","STATUS","LOCALITY","DEGREE","ROWCNT","JOIN_INDEX" FROM "_utl$_lnc_ind_parts" WHERE (tab_owner_id = userenv('SCHEMAID')
       OR ind_owner_id = userenv('SCHEMAID')
       OR EXISTS (SELECT NULL FROM sys.v$enabledprivs
                  WHERE priv_number in (-72 /* ALTER ANY INDEX */,
                                        -42 /* ALTER ANY TABLE */)))
UNION ALL
SELECT "CTYPE","INDEX_NAME","COMPONENT_NAME","TABLE_ID","TAB_OWNER_ID","IDX_ID","IND_OWNER_ID","IND_OWNER_NAME","COMP_ID","TCOMP_ID","CCOMP_ID","TCCOMP_ID","STATUS","LOCALITY","DEGREE","ROWCNT","JOIN_INDEX" FROM "_utl$_lc_ind_subs" WHERE (tab_owner_id = userenv('SCHEMAID')
       OR ind_owner_id = userenv('SCHEMAID')
       OR EXISTS (SELECT NULL FROM sys.v$enabledprivs
                  WHERE priv_number in (-72 /* ALTER ANY INDEX */,
                                        -42 /* ALTER ANY TABLE */)))

View Text - HTML Formatted

SELECT "CTYPE"
, "INDEX_NAME"
, "COMPONENT_NAME"
, "TABLE_ID"
, "TAB_OWNER_ID"
, "IDX_ID"
, "IND_OWNER_ID"
, "IND_OWNER_NAME"
, "COMP_ID"
, "TCOMP_ID"
, "CCOMP_ID"
, "TCCOMP_ID"
, "STATUS"
, "LOCALITY"
, "DEGREE"
, "ROWCNT"
, "JOIN_INDEX"
FROM "_UTL$_GNP_IND"
WHERE (TAB_OWNER_ID = USERENV('SCHEMAID') OR IND_OWNER_ID = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM SYS.V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-72 /* ALTER ANY INDEX */
, -42 /* ALTER ANY TABLE */))) UNION ALL SELECT "CTYPE"
, "INDEX_NAME"
, "COMPONENT_NAME"
, "TABLE_ID"
, "TAB_OWNER_ID"
, "IDX_ID"
, "IND_OWNER_ID"
, "IND_OWNER_NAME"
, "COMP_ID"
, "TCOMP_ID"
, "CCOMP_ID"
, "TCCOMP_ID"
, "STATUS"
, "LOCALITY"
, "DEGREE"
, "ROWCNT"
, "JOIN_INDEX"
FROM "_UTL$_GP_IND_PARTS"
WHERE (TAB_OWNER_ID = USERENV('SCHEMAID') OR IND_OWNER_ID = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM SYS.V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-72 /* ALTER ANY INDEX */
, -42 /* ALTER ANY TABLE */))) UNION ALL SELECT "CTYPE"
, "INDEX_NAME"
, "COMPONENT_NAME"
, "TABLE_ID"
, "TAB_OWNER_ID"
, "IDX_ID"
, "IND_OWNER_ID"
, "IND_OWNER_NAME"
, "COMP_ID"
, "TCOMP_ID"
, "CCOMP_ID"
, "TCCOMP_ID"
, "STATUS"
, "LOCALITY"
, "DEGREE"
, "ROWCNT"
, "JOIN_INDEX"
FROM "_UTL$_LNC_IND_PARTS"
WHERE (TAB_OWNER_ID = USERENV('SCHEMAID') OR IND_OWNER_ID = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM SYS.V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-72 /* ALTER ANY INDEX */
, -42 /* ALTER ANY TABLE */))) UNION ALL SELECT "CTYPE"
, "INDEX_NAME"
, "COMPONENT_NAME"
, "TABLE_ID"
, "TAB_OWNER_ID"
, "IDX_ID"
, "IND_OWNER_ID"
, "IND_OWNER_NAME"
, "COMP_ID"
, "TCOMP_ID"
, "CCOMP_ID"
, "TCCOMP_ID"
, "STATUS"
, "LOCALITY"
, "DEGREE"
, "ROWCNT"
, "JOIN_INDEX"
FROM "_UTL$_LC_IND_SUBS"
WHERE (TAB_OWNER_ID = USERENV('SCHEMAID') OR IND_OWNER_ID = USERENV('SCHEMAID') OR EXISTS (SELECT NULL
FROM SYS.V$ENABLEDPRIVS
WHERE PRIV_NUMBER IN (-72 /* ALTER ANY INDEX */
, -42 /* ALTER ANY TABLE */)))