My Oracle Support Banner

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.
 

Symptoms

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 :

execute sa_policy_admin.apply_schema_policy('<MY_POLICY_NAME>','MY_SCHEMA_NAME>');

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:


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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.