Spatial Is Invalid With DBA_SDO_THEMES View & Synonym (Doc ID 2251367.1)

Last updated on NOVEMBER 21, 2019

Applies to:

Symptoms

Spatial is invalid with following invalid objects/errors:

SQL> SELECT substr(comp_id,1,12)Comp_ID, Status,
  2 substr(Version,1,10)Version,
  3 substr(Comp_Name,1,40)Comp_Name,
  4 MODIFIED
  5 FROM DBA_Registry
  6 ORDER by 1,2;

COMP_ID STATUS VERSION COMP_NAME MODIFIED
------------ ---------- --------------- ---------------------------------------- --------------------
AMD OPTION OFF 11.2.0.3.0 OLAP Catalog 26-FEB-2016 04:31:47
APEX VALID 4.2.5.00.0 Oracle Application Express 17-MAR-2017 15:57:20
APS VALID 12.1.0.2.0 OLAP Analytic Workspace 17-MAR-2017 15:57:16
CATALOG VALID 12.1.0.2.0 Oracle Database Catalog Views 17-MAR-2017 15:57:06
CATJAVA VALID 12.1.0.2.0 Oracle Database Java Packages 17-MAR-2017 15:57:11
CATPROC VALID 12.1.0.2.0 Oracle Database Packages and Types 17-MAR-2017 15:57:07
CONTEXT VALID 12.1.0.2.0 Oracle Text 17-MAR-2017 15:57:12
EXF REMOVED 11.2.0.3.0 Oracle Expression Filter 25-FEB-2016 20:41:56
JAVAVM VALID 12.1.0.2.0 JServer JAVA Virtual Machine 17-MAR-2017 15:57:10
ORDIM VALID 12.1.0.2.0 Oracle Multimedia 17-MAR-2017 16:04:02
OWB VALID 11.2.0.3.0 OWB 17-MAR-2017 15:57:21
OWM VALID 12.1.0.2.0 Oracle Workspace Manager 17-MAR-2017 15:57:10
RAC VALID 12.1.0.2.0 Oracle Real Application Clusters 17-MAR-2017 15:57:21
RUL REMOVED 11.2.0.3.0 Oracle Rules Manager 25-FEB-2016 20:41:38
SDO INVALID 12.1.0.2.0 Spatial 17-MAR-2017 15:57:16
XDB VALID 12.1.0.2.0 Oracle XML Database 17-MAR-2017 15:57:15
XML VALID 12.1.0.2.0 Oracle XDK 17-MAR-2017 15:57:11
XOQ VALID 12.1.0.2.0 Oracle OLAP API 17-MAR-2017 15:57:19

18 rows selected.

SQL> -- Invalid Objects
SQL> col object_name format a40
SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
  2 FROM DBA_INVALID_OBJECTS
  3 WHERE OWNER IN ('PUBLIC','SYS','SYSTEM','XDB','ORDSYS','ORDPLUGINS','ORDDATA','MDSYS','CTXSYS')
  4 ORDER BY OWNER, OBJECT_NAME, OBJECT_TYPE;

OWNER OBJECT_NAME OBJECT_TYPE
-------------------- ---------------------------------------- -----------------------
MDSYS DBA_SDO_THEMES VIEW
PUBLIC DBA_SDO_THEMES SYNONYM

SQL> col name format A50
SQL> select OWNER, NAME, TYPE, LINE, TEXT from dba_errors
  2 where OWNER in ('PUBLIC','SYS','SYSTEM','XDB','ORDSYS','ORDPLUGINS','ORDDATA','MDSYS','CTXSYS')
  3 ORDER BY OWNER;

OWNER NAME TYPE LINE
-------------------- -------------------------------------------------- ------------ ----------
TEXT
------------------------------------------------------------------------------------------------------------
MDSYS DBA_SDO_THEMES VIEW 0
ORA-00942: table or view does not exist

Cause

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