My Oracle Support Banner

Alter Index Rebuild on Spatial index with OLS Policies fails in 18c after succeeding in 12.1 (Doc ID 2547368.1)

Last updated on APRIL 24, 2020

Applies to:

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

Symptoms

alter index my_spatial_index rebuild partition my_partition parameters ('tablespace=my_tablespace');

fails...
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-13249: internal error in spatial index: [mdidxrbd]
ORA-13249: Base table "MY_USER"."MY_TABLE" is subject to VPD policy
ORA-06512: at "MDSYS"."SDO_INDEX_METHOD_10I", line 571

Also...
create index my_spatial_index on my_user.my_table (spatial_column) indextype is mdsys.spatial_index parameters ('work_tablespace=my_work_tablespace layer_gtype=collection tablespace=my_tablespace') local;

fails...
ORA-29858: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in spatial index: [mdidxrbd]
ORA-13249: Base table "MY_USER"."MY_TABLE" is subject to VPD policy
ORA-06512: at "MDSYS"."SDO_INDEX_METHOD_10I", line 571

This did not error in 12.1.0.2.

The tables are protected with an Oracle Label Security policy.

Dropping the policy from the table with sa_policy_admin.remove_table_policy eliminates the error.

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


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