My Oracle Support Banner

Oracle Spatial Is Invalid And Recompiling Invalid Objects Raises ORA-00904: "SDO_ROOT_MBR": Invalid Identifier (Doc ID 1370015.1)

Last updated on JANUARY 30, 2022

Applies to:

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


In Oracle Server Oracle Spatial component is invalid in the registry and there are many MDSYS invalid objects:

OWNER                          OBJECT_TYPE         OBJECT_NAME
------------------------------ ------------------- ---------------------------------
MDSYS                          FUNCTION            SDO_JOIN
MDSYS                          FUNCTION            SDO_PQRY
MDSYS                          PACKAGE BODY        MD2
MDSYS                          PACKAGE BODY        SDO_3GL
MDSYS                          PACKAGE BODY        SDO_IDX
MDSYS                          PACKAGE BODY        SDO_RELATE_MASK
MDSYS                          PACKAGE BODY        SDO_ROUTER_PARTITION
MDSYS                          PACKAGE BODY        SDO_TUNE
MDSYS                          VIEW                ALL_SDO_INDEX_INFO
MDSYS                          VIEW                ALL_SDO_INDEX_METADATA
MDSYS                          VIEW                MY_SDO_INDEX_METADATA
MDSYS                          VIEW                SDO_RELATEMASK_TABLE
MDSYS                          VIEW                USER_SDO_INDEX_INFO
MDSYS                          VIEW                USER_SDO_INDEX_METADATA
PUBLIC                         SYNONYM             ALL_SDO_INDEX_INFO
PUBLIC                         SYNONYM             ALL_SDO_INDEX_METADATA
PUBLIC                         SYNONYM             MY_SDO_INDEX_METADATA
PUBLIC                         SYNONYM             SDO_INDEX_METADATA
PUBLIC                         SYNONYM             SDO_JOIN
PUBLIC                         SYNONYM             SDO_PQRY 
PUBLIC                         SYNONYM             SDO_RELATEMASK_TABLE
PUBLIC                         SYNONYM             USER_SDO_INDEX_INFO
PUBLIC                         SYNONYM             USER_SDO_INDEX_METADATA

The most frequent error shown while compiling the invalid objects is:
ORA-00904: "SDO_ROOT_MBR": invalid identifier


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.