DBA Data[Home] [Help]

VIEW: SYS._USER_REPL_NESTED_TABLE_NAMES

Source

View Text - Preformatted

select nt.table_name
from "_DBA_REPL_NESTED_TABLE_NAMES" nt, sys.user$ u
where nt.owner = u.name
and   u.user#  = userenv('SCHEMAID')
View Text - HTML Formatted

SELECT NT.TABLE_NAME FROM "_DBA_REPL_NESTED_TABLE_NAMES" NT
, SYS.USER$ U WHERE NT.OWNER = U.NAME AND U.USER# = USERENV('SCHEMAID')