ORA-600 [6856], ORA-600 [ktsf_rsp2] or ORA-600 [6006] Using Global Temporary Tables

(Doc ID 335714.1)

Last updated on JANUARY 27, 2012

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.5.0 to 10.2.0.1 - Release: 8.1.5 to 10.2
Information in this document applies to any platform.

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 Trunc_Tab (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], [], [], [], [], [], []

Cause

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