DBA Data[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