VIEW: MDSYS.ALL_MD_TABLESPACES

Source

View Text - Preformatted

select owner,mdtname,tsname,seq,decode(status,0,'IN-ACTIVE',1,'ACTIVE')
  from md$pts
 where owner = user
    or mdtname in ( select table_name
                      from all_tab_privs
                     where grantee = user )

View Text - HTML Formatted

SELECT OWNER
, MDTNAME
, TSNAME
, SEQ
, DECODE(STATUS
, 0
, 'IN-ACTIVE'
, 1
, 'ACTIVE')
FROM MD$PTS
WHERE OWNER = USER OR MDTNAME IN ( SELECT TABLE_NAME
FROM ALL_TAB_PRIVS
WHERE GRANTEE = USER )