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

Last updated on AUGUST 15, 2016

Applies to:

Oracle Spatial and Graph - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Oct-2013***


Goal

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.






Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms