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$_tts_tab_tablespace_view tts
where (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
OR EXISTS ( SELECT * FROM sys.session_roles
WHERE role='SELECT_CATALOG_ROLE' ))
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$_TTS_TAB_TABLESPACE_VIEW TTS
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0
OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))
|
|
|