Oracle Spatial index creation fails with ORA-29855 if OLS is enabled at schema Level
(Doc ID 1093674.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Spatial and Graph - Version 10.2.0.3 and later
Information in this document applies to any platform.
It is not possible to create successfully an R-Tree Spatial index on tables with mdsys.sdo_geometries columns if these tables belong to schemas with OLS policies enabled.
An OLS policy is enabled at schema level in this way :
With OLS enabled at the schema level the creation of R-Tree spaitial index on the mdsys.geometries
columns ends with
ORA-29855 error occured during index creation errors
which is caused by ORA-00947 error 'not enough values'.
the following example shows the error faced:
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