Failed To Increase SDO_ORDINATES Varray in 19C version using sdoupgeom.sql
(Doc ID 2864048.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Spatial and Graph - Version 19.1.0.0.0 to 19.9.0.0.0 [Release 12.2]Information in this document applies to any platform.
Symptoms
Increasing SDO_ORDINATES varray in 19C fails to complete because invalid objects related to Spatial(e.g. indexes) are detected by the script
Invalid indexes and spatial objects are expected to be reported during script execution.
Example:
alter type mdsys.sdo_ordinate_array modify limit 10000000 cascade;
alter type mdsys.sdo_ordinate_array modify limit 10000000 cascade
*
ERROR at line 1:
ORA-22324: altered type has compilation errors
ORA-22332: a dependent object in schema "XXXXXX" has errors.
ORA-29925: cannot execute MDSYS.SDO_INDEX_METHOD_TEMP.ODCIINDEXUPDATE
Changes
Upgrade to 19C
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |