DBA Data[Home] [Help]

VIEW: SYS.USER_XML_OUT_OF_LINE_TABLES

Source

View Text - Preformatted

select SCHEMA_URL, --schema URL
       SCHEMA_OWNER,  --schema owner
       TABLE_NAME --out of line table name
from DBA_XML_OUT_OF_LINE_TABLES
where
TABLE_OWNER = USER
View Text - HTML Formatted

SELECT SCHEMA_URL
, --SCHEMA URL SCHEMA_OWNER
, --SCHEMA OWNER TABLE_NAME --OUT OF LINE TABLE NAME FROM DBA_XML_OUT_OF_LINE_TABLES WHERE TABLE_OWNER = USER