Spatial Is Invalid With Package MDSYS.SDO_OLS_DIRECTORY (Doc ID 2270088.1)

Last updated on AUGUST 08, 2023

Applies to:

Symptoms

Spatial is invalid with invalid packages MDSYS.SDO_OLS_DIRECTORY:

*************************************************************************
Database Components:
*************************************************************************
--> OLAP Catalog 11.2.0.4.0 VALID
--> OLAP Analytic Workspace 11.2.0.4.0 VALID
--> Oracle Database Catalog Views 11.2.0.4.0 VALID
--> Oracle Database Java Packages 11.2.0.4.0 VALID
--> Oracle Database Packages and Types 11.2.0.4.0 VALID
--> Oracle Text 11.2.0.4.0 VALID
--> JServer JAVA Virtual Machine 11.2.0.4.0 VALID
--> Oracle Data Mining 11.2.0.4.0 VALID
--> Oracle Multimedia 11.2.0.4.0 VALID
--> Oracle Real Application Clusters 11.2.0.4.0 INVALID
--> Spatial 11.2.0.4.0 INVALID
--> Oracle XML Database 11.2.0.4.0 VALID
--> Oracle XDK 11.2.0.4.0 VALID
--> Oracle OLAP API 11.2.0.4.0 VALID

*************************************************************************
Invalid Objects in MDSYS Schema:
*************************************************************************
.. MDSYS.SDO_OLS_DIRECTORY - PACKAGE BODY

While re-compiling/re-creating a package MDSYS.SDO_OLS_DIRECTORY fails with the
following errors:

SQL> alter package MDSYS.SDO_OLS_DIRECTORY compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors package body MDSYS.SDO_OLS_DIRECTORY
Errors for PACKAGE BODY MDSYS.SDO_OLS_DIRECTORY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00753: malformed or corrupted wrapped unit

SQL> @$ORACLE_HOME/md/admin/prvtwsoy.plb

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY MDSYS.SDO_OLS_DIRECTORY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
34/5 PL/SQL: SQL Statement ignored
39/13 PL/SQL: ORA-00942: table or view does not exist
59/5 PL/SQL: SQL Statement ignored
65/13 PL/SQL: ORA-00942: table or view does not exist
599/5 PL/SQL: SQL Statement ignored
619/15 PL/SQL: 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.