ORA-600 [6856], ORA-600 [ktsf_rsp2] or ORA-600 [6006] Using Global Temporary Tables (Doc ID 335714.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

The following errors are received:

ORA-600 [6856], [0], [0], [], [], [], [], []
ORA-600 [ktsf_rsp2], [4265609], [4265610], [], [], [], [], []

or

ORA-600 [6006], [1]

The application uses global temporary tables, and does truncates within autonomous transactions against those tables, for example, via a procedure:

CREATE OR REPLACE PROCEDURE <procedure name> (tabname VARCHAR2)
IS
   PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
   EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || tabname;
END;
/ 

If you have an index defined on the global temporary table, it is also possible to get an error like:

ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []

Changes

Cause

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