Failing to insert into table getting error: ORA-00600: internal error code, arguments: [ktssinseg2] I am facing problems inserting records into my oracle database 12C R2. I have no Oracle Support. All this time I was able to do inserts into my database, but all of a sudden it is now failing. Below is the query and error:

SQL&gt; INSERT INTO MV_IN_SMS_TOTAL SELECT * FROM mv_in_sms_total@newdwhlink.com WHERE START_DATE = '20191101';
INSERT INTO MV_IN_SMS_TOTAL SELECT * FROM mv_in_sms_total@newdwhlink.com WHERE START_DATE = '20191101'
                                   *
ERROR at line 1:
ORA-00600: internal error code, arguments: [ktssinseg2], [60], [7],
[289598865], [], [], [], [], [], [], [], []
You could try to copy the table into a new object:

CREATE TABLE newtab AS SELECT * FROM MV_IN_SMS_TOTAL 


Try to do your inserts into the new table. If that solves the problem and the problem is isolated to that specific object (table), and you use that as a workaround.

RENAME TABLE MV_IN_SMS_TOTAL TO MV_IN_SMS_TOTAL_OLD;
CREATE TABLE MV_IN_SMS_TOTAL AS SELECT * FROM MV_IN_SMS_TOTAL_OLD;


Note that all auxiliary objects must be created. Indexes, constraints, triggers, you name it - and privileges.

Regards,

Daniel