My Oracle Support Banner

How to validate Oracle Spatial in the DBA_REGISTRY (Doc ID 1100898.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Spatial and Graph - Version and later
Information in this document applies to any platform.


This document will explain how to validate Oracle Spatial in the DBA_REGISTRY if it is currently INVALID.

If there were invalid Spatial objects in the database, the Oracle Spatial component will be set to INVALID in the dba_registry.  The component status may have been changed during an install, upgrade or if running utlrp.sql. 

If the invalid Oracle Spatial objects have been corrected and the user MDSYS does not have any invalid objects, then the DBA_REGISTRY validation procedure for Oracle Spatial will need to be run again.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.