[Home] [Help]
VIEW: SYS._DBA_REPL_NESTED_TABLE_NAMES
Source
View Text - Preformatted
select u.name, o.name from sys.user$ u, sys.obj$ o, sys.tab$ t
where u.user# = o.owner#
and o.obj# = t.obj#
and bitand(t.property, 8192) = 8192
View Text - HTML Formatted
SELECT U.NAME
, O.NAME
FROM SYS.USER$ U
, SYS.OBJ$ O
, SYS.TAB$ T
WHERE U.USER# = O.OWNER#
AND O.OBJ# = T.OBJ#
AND BITAND(T.PROPERTY
, 8192) = 8192