ORA-04036 When Creating An Spatial Index On 19.5
(Doc ID 2716144.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.1.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
On : 19.1.0.0.0 version, Internal bugs
When attempting to create an spatial index
the following error occurs.
ERROR
-----------------------
SQL> CREATE INDEX CTU_URB_A_BL_3D_SIDX ON CTU_URB_A_BL_3D ("GEOM")
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX" ;02:39:58 2
CREATE INDEX CTU_URB_A_BL_3D_SIDX ON CTU_URB_A_BL_3D ("GEOM")
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Error in Spatial index: index build failed
ORA-13249: Error in spatial index: [mdrcrtxfergm]
ORA-13249: Error in spatial index: [mdpridxtxfergm]
ORA-29400: data cartridge error
ORA-00600: internal error code, arguments: [kope2upic2954], [349291],
[1468069], [0], [], [], [], [], [], [], [], []
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
Changes
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 |