VIEW: MDSYS.USER_MD_PARTITIONS

Source

View Text - Preformatted

select 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

View Text - HTML Formatted

SELECT 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