VIEW: CTXSYS.CTX_EXTRACT_POLICIES

Source

View Text - Preformatted

select
  i.idx_name epl_name,
  u.name     epl_owner
  from dr$index i, sys.user$ u
  where INSTR(i.idx_option, 'E') > 0
    and i.idx_owner# = u.user#

View Text - HTML Formatted

SELECT I.IDX_NAME EPL_NAME
, U.NAME EPL_OWNER
FROM DR$INDEX I
, SYS.USER$ U
WHERE INSTR(I.IDX_OPTION
, 'E') > 0
AND I.IDX_OWNER# = U.USER#