Search Results sdo_rtree_admin




Overview
Explore in AI Chat

Overview

MDSYS.SDO_RTREE_ADMIN is an Oracle Spatial database package that provides the administrative and operational foundation for R-tree spatial indexing. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is delivered as part of the standard Oracle Database Spatial option and resides in the MDSYS schema rather than in an EBS application schema. Its business function is to support the creation, maintenance, and querying of R-tree indexes on SDO_GEOMETRY columns, which underpin spatial data operations used by EBS modules that store geographic or geometric information. Although the package is owned by MDSYS, it is exposed to the EBS application layer through a public synonym, SDO_RTREE_ADMIN, allowing APPS-schema code and dependent EBS objects to invoke it without schema qualification. The package is documented in ETRM as VALID with an API classification of OTHER, indicating that it is a supporting database component rather than an EBS application programming interface in the conventional sense. Applications searching for rtree_index_method will encounter this package because it is directly coupled to the RTREE_INDEX_METHOD object and to the RTREE_FILTER and RTREE_NN routines that perform index-based filtering and nearest-neighbor processing.

Key Procedures and Functions

ETRM documentation for this object lists no explicitly documented procedures or functions at the 12.2.2 level, and no parameter lists are published. The package body nonetheless implements the internal driver logic required for R-tree index management, and its presence is established through its dependency graph rather than through individually catalogued entry points. Because the metadata identifies zero documented procedures, no procedure names, signatures, or parameter lists are asserted here. Administrators and developers should treat the package as an internal engine component and should not call its members directly. The functions of interest to EBS users, such as spatial filtering and nearest-neighbor queries, are surfaced through the referenced objects RTREE_FILTER and RTREE_NN rather than through direct invocation of SDO_RTREE_ADMIN.

Tables Accessed

The documented table reference for this package, resolved through APPS synonyms, is DUAL. Use of DUAL is consistent with internal metadata validation, method dispatch, and lightweight initialization performed during index setup and query execution. Beyond DUAL, the package's dependency information identifies SDORIDTAB, an internal Spatial table used to persist R-tree index metadata, and the type SDO_MBR, which represents minimum bounding rectangles. These dependencies confirm that SDO_RTREE_ADMIN reads and writes index structure information rather than business data belonging to EBS transaction tables. No EBS application tables are documented as being accessed by this package.

Usage Notes

SDO_RTREE_ADMIN is not intended for direct invocation from Oracle Forms, concurrent programs, or custom EBS code. It is invoked indirectly by the Oracle Spatial runtime whenever an R-tree spatial index is created, rebuilt, or used to satisfy a spatial predicate. The package is referenced by SDO_TUNE and by the RTREE_FILTER and RTREE_NN components, and it is exposed publicly through the SDO_RTREE_ADMIN synonym. EBS customers encountering this object during dependency analysis, patching, or invalid-object reconciliation should recognize it as a standard MDSYS-owned library delivered with the Spatial option. Custom development that requires R-tree functionality should operate against the supported Spatial operators and index types, not against this package's internal routines.