ALL_XML_OUT_OF_LINE_TABLES

Previous Next JavaScript must be enabled to correctly display this content

3.142 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 Note: See the See Also note below for links to more information about the `schemaurl` attribute for an XML schema.
`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:

"DBA_XML_OUT_OF_LINE_TABLES"
"USER_XML_OUT_OF_LINE_TABLES"
Oracle XML DB Developer’s Guide for information about registering an XML schema with Oracle XML DB
Oracle XML DB Developer’s Guide for information about restrictions for an XML schema URL