Search Results sdo_nn_distance




Overview
Explore in AI Chat

Overview

MDSYS.PRVT_IDX is an internal Oracle Spatial and Graph package that implements the private indexing infrastructure underpinning the spatial index types shipped with the Oracle Database. In Oracle EBS 12.1.1 and 12.2.2, where the MDSYS schema is installed as part of the standard database option set, this package provides the runtime behavior behind spatial index creation, maintenance, and lookup. It is not an Applications-owned object and carries no EBS business logic; instead it acts as the internal engine supporting the SDO_INDEX_METHOD_10I index type and related geometry operations that EBS deployments may invoke through Oracle Spatial-enabled functionality such as site/asset geocoding, network routing, and spatial reporting.

The package is marked VALID in MDSYS and is classified as OTHER in the ETRM repository. Its principal role is to expose and manage the internal index metadata and index-type context required by Oracle's extensible indexing (ODCIIndex) framework.

Key Procedures and Functions

The ETRM metadata documents no public procedures or functions for this object. This is consistent with its designation as a private package: its entry points are consumed by other MDSYS packages rather than by external callers. Functionality is exposed through the ODCIIndex interface referenced in its dependency list, including ODCIINDEXCTX, ODCIINDEXINFO, and ODCIPARTINFO, which supply the index context, index information, and partition information structures used during index DDL and DML. The presence of SDO_INDEX_METHOD_10I in the dependency list confirms that PRVT_IDX supplies helper logic to the R-tree spatial index implementation. Because no parameterized signatures are published in the metadata, no procedure-level API should be assumed or invoked directly.

Tables Accessed

Per the documented references, PRVT_IDX reads from ALL_OBJECTS, ODCICONST, and PLITBLM through APPS synonyms. ALL_OBJECTS is queried to resolve index and object metadata during validation and dependency checks. ODCICONST supplies the constants used by the extensible indexing framework, such as return codes for ODCIIndex methods. PLITBLM is an internal PL/SQL table used for in-memory index metadata handling. The package also references SDO_GEOMETRY and ST_GEOMETRY types and the STANDARD package, which are required for geometry typing and base PL/SQL functionality.

Usage Notes

PRVT_IDX is never invoked directly from EBS forms, concurrent programs, or custom application code. It is called indirectly whenever a spatial index is created, altered, or rebuilt through DDL such as CREATE INDEX ... INDEXTYPE IS MDSYS.SPATIAL_INDEX, and during optimizer access-path evaluation of SDO_NN, SDO_NN_DISTANCE, and SDO_JOIN operations. The package is referenced by sixteen other MDSYS packages, including SDO_INDEX_METHOD_10I, SDO_PRIDX, SDO_RTREE_ADMIN, SDO_SAM, SDO_PC_PKG, SDO_TIN_PKG, and the MDPRVT_IDX family, indicating its role as a shared low-level utility layer. Because it depends on internal MDSYS structures, it is subject to change across database patch levels; EBS customers should treat it as unsupported for direct invocation and rely only on the documented Oracle Spatial public APIs. Any errors raised from PRVT_IDX during index maintenance typically require Oracle Spatial support engagement rather than application-level troubleshooting.