VIEW: MDSYS.ALL_MD_PARTITIONS

Source

View Text - Preformatted

select owner,mdtname,pname,decode(class,0,'LEAF',1,'NODE',2,'PERSISTENT NODE'),
       cclv,cchh,decode(olst,1,'ONLINE','OFFLINE'),archd
  from md$ptab
 where owner = user
    or mdtname in ( select table_name
		      from all_tab_privs
                     where grantee = user )

View Text - HTML Formatted

SELECT OWNER
, MDTNAME
, PNAME
, DECODE(CLASS
, 0
, 'LEAF'
, 1
, 'NODE'
, 2
, 'PERSISTENT NODE')
, CCLV
, CCHH
, DECODE(OLST
, 1
, 'ONLINE'
, 'OFFLINE')
, ARCHD
FROM MD$PTAB
WHERE OWNER = USER OR MDTNAME IN ( SELECT TABLE_NAME
FROM ALL_TAB_PRIVS
WHERE GRANTEE = USER )