VIEW: MDSYS.ALL_MD_TABLES

Source

View Text - Preformatted

select owner,mdtname,decode(class,0,'NON-PARTITIONED',1,'PARTITIONED'),
       ptseq,hwm,oflp,decode(cm,0,'ESTIMATE',1,'EXACT')
  from md$tab
 where owner = user
    or mdtname in ( select table_name
		      from all_tab_privs
                     where grantee = user )

View Text - HTML Formatted

SELECT OWNER
, MDTNAME
, DECODE(CLASS
, 0
, 'NON-PARTITIONED'
, 1
, 'PARTITIONED')
, PTSEQ
, HWM
, OFLP
, DECODE(CM
, 0
, 'ESTIMATE'
, 1
, 'EXACT')
FROM MD$TAB
WHERE OWNER = USER OR MDTNAME IN ( SELECT TABLE_NAME
FROM ALL_TAB_PRIVS
WHERE GRANTEE = USER )