DBA Data[Home] [Help]

VIEW: SYS._ALL_REPL_NESTED_TABLE_NAMES

Source

View Text - Preformatted

select nt.owner, nt.table_name
from "_DBA_REPL_NESTED_TABLE_NAMES" nt, all_objects o
where nt.owner=o.owner and nt.table_name=o.object_name
View Text - HTML Formatted

SELECT NT.OWNER
, NT.TABLE_NAME FROM "_DBA_REPL_NESTED_TABLE_NAMES" NT
, ALL_OBJECTS O WHERE NT.OWNER=O.OWNER
AND NT.TABLE_NAME=O.OBJECT_NAME