AFTER UPGRADING TO 10.2.0.3 SPATIAL IS INVALID WITH RTREE_INDEX INDEXTYPE INVALID. (Doc ID 781154.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Jan-2014***


Symptoms

After upgrading to 10.2.0.3, the SPATIAL component and the RTREE_INDEX indextype object are  INVALID.

SQL> select comp_id, control, schema, version, status, comp_name from dba_registry where comp_id='SDO';

COMP_ID     VERSION     STATUS     COMP_NAME
----------- ----------- ---------- ----------------
SDO         10.2.0.3.0  INVALID    Spatial


SQL> select object_name, object_type, status from dba_objects where owner='MDSYS' and status <> 'VALID'order by object_name;

OBJECT_NAME OBJECT_TYPE STATUS
----------- ----------- ------

RTREE_INDEX INDEXTYPE   INVALID

Cause

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