My Oracle Support Banner

ORA-00600 [qctbyt : bfc], [4000], [6000] when running CTAS or create/compile view. (Doc ID 2428701.1)

Last updated on OCTOBER 03, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Attempting to run CTAS or CREATE VIEW the following error is raised:

ORA-00600: internal error code, arguments: [qctbyt : bfc], [4000], [6000], [1], [873], [1], [1], [0], []

 The Call Stack Trace in the associated incident trace file shows:

qctbyt <- qctfrc <- qctsto2c <- koksobc <- cvwgdty <- cvwgcd <- ctcpre1 <- opitca
<- kksLoadChild <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o

Attempting to compile the view also generates ORA-00600: internal error code, arguments: [qctbyt : bfc] even for nls_length_semantics = byte.

Facts regarding the base table for which CTAS or CREATE VIEW is failing:

1.It has a column of type VARCHAR2 (xxxx BYTE) or NVARCHAR.Due to this column CTAS or CREATE VIEW statements are failing.

2.It was also created on 12.2 with CTAS across a database link from a remote database with single-byte characterset .The characterset of current database is multibyte.

Case scenario:

a.In a singlebyte database we have table t1:

create table tc.t1 (A number, B varchar2 (4000 byte));

b.In multibyte database table t2 is created from t1 via dblink:

create table t2 as (select * from t1@dblink1);

c.The following fails with ORA-600 [qctbyt : bfc]:

create table t3 as (select * from t2);

 

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
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.