CREATE GLOBAL TEMPORARY TABLE Fails With ORA-00600[15267] (Doc ID 801325.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.1.0.5
This problem can occur on any platform.

Symptoms

The following symptoms will be seen :-

a) Issue is seen on <10gR2 databases

b) ORA-00600[15267] error is reported in alert log :-

ORA-00600: internal error code, arguments: [15267], [4255585972], [], [] ----> address will vary

c) Current SQL statement will be reported in the ORA-600 trace file and will be similar to :-

CREATE GLOBAL TEMPORARY TABLE "SYS"."SYS_TEMP_0FDA716B4_CE747271" ......

d) Stack trace will be similar to the following :-

Function List (to Full stack) (to Summary stack)
kkdlcob <- ctcdrv <- opiexe <- opiosq0 <- opiall0
<- opikpr <- opiodr <- rpidrus <- skgmstack <- rpidru
<- rpiswu2 <- kprball <- qks3tCrtTmpTabl <- 572 <- qkswc3Tmain
<- qkswcDriver <- qkswcDriver <- qkswcDriver <- opitca <- kkssbt
<- kksfbc <- opiexe <- opipls <- opiodr <- rpidrus
<- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0
<- psdnal <- pevm_EXECC <- pfrrun <- peicnt <- kkxexe
<- opiexe <- opiall0 <- kpoal8 <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- main <- start

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