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?