Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Unable to delete from table containing spatial index - ORA-29876: failed in the execution of the ODCIINDEXDELETE routine

AndyH6 days ago — edited 6 days ago

Oracle 19.16.0.0.0

ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-29400: data cartridge error
ORA-01688: unable to extend table MDSYS.SDO_TXN_JOURNAL_REG partition SYS_P36249 by 128 in tablespace SYSAUX
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 973
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 508

ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
ORA-29400: data cartridge error
ORA-01688: unable to extend table MDSYS.SDO_TXN_JOURNAL_REG partition SYS_P36249 by 128 in tablespace SYSAUX
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 973
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 508
ORA-06512: at "IDS.OS_INTERFACE", line 259

Line 259 is where I delete from a table that contains spatial data (each row contains a single location). The deletion may involve 80k rows from a total of 25m.

After the initial failure, an additional data file was added to the SYSAUX tablespace, auto-extending to a maximum of 30Gb. After the second failure, it was found that the new file was unused, and the original was 50% used.

Any ideas?

Added 6 days ago

0 comments

30 views