SDO_FILTER Fails With ORA-600 [kdsgrp1] After DELETE,INSERT,DELETE,INSERT,COMMIT
Last updated on JUNE 14, 2018
Applies to:Oracle Spatial and Graph - Version 22.214.171.124 and later
Information in this document applies to any platform.
Given the table below:
If a COMMIT is done after every last INSERT in a series, then NO error is generated, i.e
INSERT => INSERT => commit => DELETE => INSERT => commit => DELETE => INSERT => commit
Dropping and recreating the related spatial index temporarily avoids the error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms