SELECT
u.username owner
, t.name table_name
, decode (t.type#, 2, 'TABLE', 'VIEW') table_type
FROM
dba_users u
, sys.obj$ t
WHERE u.user_id = t.owner#
AND t.type# IN (2,4)
WITH READ ONLY
View Text - HTML Formatted
SELECT
U.USERNAME OWNER
, T.NAME TABLE_NAME
, DECODE (T.TYPE# , 2 , 'TABLE' , 'VIEW') TABLE_TYPE
FROM
DBA_USERS U
, SYS.OBJ$ T
WHERE U.USER_ID = T.OWNER#
AND T.TYPE# IN (2 , 4)
WITH READ ONLY