[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')