Search Results index_owner




Overview
Explore in AI Chat

Overview

SYS.DBMS_XMLTABLEINDEX is a server-side PL/SQL package body that forms part of Oracle's XML DB infrastructure, exposed within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments through the SYS schema. Its business function is the programmatic management of XMLIndex structures associated with XMLType data. XMLIndex provides a structured, relational-style indexing mechanism for XML documents stored in Oracle Database, and DBMS_XMLTABLEINDEX offers the administrative API required to create and maintain these index definitions without requiring direct DDL manipulation by the developer or DBA.

In an EBS context, XML data is frequently encountered in modules such as Order Management, Purchasing, and Oracle Advanced Pricing, where XML payloads are stored or exchanged. Maintaining efficient access paths to those payloads is essential for query performance, and this package supplies the low-level routines that allow index components, groups, and columns to be manipulated independently. The package is classified under the ETRM taxonomy as OTHER, reflecting that it is a kernel database utility rather than an EBS application API. It is owned by SYS and is not referenced by any other documented EBS package, confirming its role as a foundational database component rather than an application-tier dependency.

Key Procedures and Functions

The package exposes seven documented procedures, each implemented as an external C routine bound to the SYS.XMLTABLEINDEX_LIB shared library via the language C clause and executed with context. Every routine accepts an index_owner parameter as its primary identifier, which is the attribute most commonly associated with the user search term "index_owner."

  • ALTERINDEXMODIFY — Modifies the definition of an existing XMLIndex, accepting owner, name, group, table, column, and clause parameters to alter the index structure in place.
  • ALTERINDEXADDGROUP — Adds a new index group to an existing XMLIndex, allowing logical partitioning of indexed content.
  • ALTERINDEXDROPGROUP — Removes an index group from an existing XMLIndex.
  • ALTERINDEXDROPCOLUMN — Drops a specific column from an index group, using a continuation table and column to identify the target.
  • ALTERINDEXADDCOLUMN — Adds a new column to an existing index group within the XMLIndex definition.
  • ALTERINDEXRENAMECOLUMN — Renames an indexed column while preserving its group association.
  • CREATEINDEX — Establishes a new XMLIndex over XMLType data, serving as the primary entry point for index construction.

All procedures share a consistent signature pattern: an owner and index name to locate the target, optional group and column qualifiers, and a CLOB clause describing the index or storage attributes. The INDICATOR bindings permit NULL values on optional arguments.

Tables Accessed

The ETRM metadata documents no tables accessed via APPS synonyms, which is consistent with the package's nature as a SYS-owned kernel utility. Its operations act against Oracle XML DB dictionary objects and XMLIndex metadata stored in the SYS schema, such as the XML index tables and associated structures maintained internally by XML DB. Because the routines are implemented in C through XMLTABLEINDEX_LIB, the underlying dictionary manipulation is performed below the SQL layer.

Usage Notes

DBMS_XMLTABLEINDEX is not invoked directly by standard EBS forms or concurrent programs. It is typically called from custom PL/SQL code, database administration scripts, or upgrade utilities that must programmatically create or adjust XMLIndex structures on XMLType columns. Access is restricted to users with EXECUTE privilege on the SYS package, normally SYS or SYSDBA-level accounts. When troubleshooting indexing issues on XMLType columns in EBS 12.1.1 or 12.2.2, DBAs may trace calls to these procedures; the "index_owner" argument is the usual point of reference when identifying which schema owns the affected XMLIndex.