Nekde jsem pouzil tohle, nevim jestli je to presne to, co hledas:
select View_Name as Table_Name
from all_views
where not view_name like ''%$%'' and owner not in (''SYS'', ''CTXSYS'', ''SYSTEM'', ''DBSNMP'')
union all
SELECT Table_Name
FROM user_tables
where not table_name like ''%$%''
order by Table_Name;