My Oracle Support Banner

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:

Oracle Database - 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 <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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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