DBA Data[Home] [Help]
Skip to content

VIEW: SYS.DATAPUMP_TABLE_DATA

Source

View Text - Preformatted

select htype,name,seq#
 from sys.metanametrans$
 where properties!=0
 and name like '%/TABLE_DATA'
 and name not like '%INDEX%'
 and name not like '%VIEWS_AS_TABLES%'
 and name not like '%OPTIONS%'
View Text - HTML Formatted

SELECT HTYPE
, NAME
, SEQ#
FROM SYS.METANAMETRANS$
WHERE PROPERTIES!=0
AND NAME LIKE '%/TABLE_DATA'
AND NAME NOT LIKE '%INDEX%'
AND NAME NOT LIKE '%VIEWS_AS_TABLES%'
AND NAME NOT LIKE '%OPTIONS%'