ALL_XML_OUT_OF_LINE_TABLES

ALL_XML_OUT_OF_LINE_TABLES descibes all the out of line tables connected to a given root table for the same schema accessible to the current user.

Related Views

  • DBA_XML_OUT_OF_LINE_TABLES describes all the out of line tables connected to a given root table for the same schema in the database.

  • USER_XML_OUT_OF_LINE_TABLES describes all the out of line tables connected to a given root table for the same schema owned by the current user. This view does not display the TABLE_OWNER column.

Column Datatype NULL Description

SCHEMA_URL

VARCHAR2(700)

  

The URL of the schema within which the out of line table is defined

SCHEMA_OWNER

VARCHAR2(128)

  

Owner of the schema

TABLE_NAME

VARCHAR2(128)

  

Name of the out of line table

TABLE_OWNER

VARCHAR2(128)

  

Owner of the out of line table

See Also: