select htype,name,seq#
from sys.metanametrans$
where properties!=0
and name like '%/TABLE_DATA'
and name not like '%INDEX%'
and name not like '%VIEWS_AS_TABLES%'
and name not like '%OPTIONS%'
View Text - HTML Formatted
SELECT HTYPE , NAME , SEQ#
FROM SYS.METANAMETRANS$
WHERE PROPERTIES!=0
AND NAME LIKE '%/TABLE_DATA'
AND NAME NOT LIKE '%INDEX%'
AND NAME NOT LIKE '%VIEWS_AS_TABLES%'
AND NAME NOT LIKE '%OPTIONS%'