How to validate Oracle Spatial in the DBA_REGISTRY
Last updated on JANUARY 19, 2018
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***
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.
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