VIEW: CTXSYS.CTX_USER_EXTRACT_STOP_ENTITIES

Source

View Text - Preformatted

select
  i.idx_name        ese_policy_name,
  e.ese_name        ese_name,
  e.ese_type        ese_type,
  decode(e.ese_status,
         0,'not compiled',
         1, 'to be deleted',
         2, 'compiled',
         3, 'subset') ese_status,
  e.ese_comments    ese_comments
  from dr$user_extract_stop_entity e, dr$index i
where i.idx_owner# = userenv('SCHEMAID')
  and e.ese_pol_id = i.idx_id

View Text - HTML Formatted

SELECT I.IDX_NAME ESE_POLICY_NAME
, E.ESE_NAME ESE_NAME
, E.ESE_TYPE ESE_TYPE
, DECODE(E.ESE_STATUS
, 0
, 'NOT COMPILED'
, 1
, 'TO BE DELETED'
, 2
, 'COMPILED'
, 3
, 'SUBSET') ESE_STATUS
, E.ESE_COMMENTS ESE_COMMENTS
FROM DR$USER_EXTRACT_STOP_ENTITY E
, DR$INDEX I WHERE I.IDX_OWNER# = USERENV('SCHEMAID')
AND E.ESE_POL_ID = I.IDX_ID