Spatial has Objects which Fail to Compile with PLS-00801: internal error [hshuid:LU invalid] after Running sdoupggeom.sql to Increase the Ordinate Array Size on a Pluggable Database

(Doc ID 2341081.1)

Last updated on DECEMBER 19, 2017

Applies to:

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

Symptoms

On a pluggable database (PDB), the sdoupggeom.sql script was run to increase the size of ordinate arrays to support geometries with up to 10M ordinates.

After this, the Spatial component became invalid as well as the following objects:


These objects fail to compile with the error below:

PLS-00801: internal error [hshuid:LU 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