VIEW: SYS.KU$_PLUGTS_TSNAME_INDEXP_VIEW

Source

View Text - Preformatted

select '1','0',
  null, tts.obj_num, tts.partobj,
  'DBMS_PLUGTS','SYS',
  0,
  101,
  0,
  tts.ts_name,tts.ts_num,
  null, null, null, null, null
  FROM sys.ku$_ttsp_idx_tablespace_view tts
  where bitand(tts.poflags,1)=1 and
        (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
                 OR EXISTS ( SELECT * FROM sys.session_roles
                    WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, NULL
, TTS.OBJ_NUM
, TTS.PARTOBJ
, 'DBMS_PLUGTS'
, 'SYS'
, 0
, 101
, 0
, TTS.TS_NAME
, TTS.TS_NUM
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SYS.KU$_TTSP_IDX_TABLESPACE_VIEW TTS
WHERE BITAND(TTS.POFLAGS
, 1)=1 AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))