My Oracle Support Banner

CTAS or CREATE / Compile a VIEW = ORA-600[qctbyt : bfc] (Doc ID 2428701.1)

Last updated on FEBRUARY 20, 2019

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 perform a CTAS (create table as select) 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

 

The same ORA-600[qctbyt : bfc] error occurs when attempting to compile a view, even for nls_length_semantics = byte.

 

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

1.  It has a column of type VARCHAR2 (xxxx BYTE) or NVARCHAR.  Due to this column, the 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 character set.  The character set of the current database is multibyte.

 

Steps to reproduce:

a.  In a single byte 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 the ORA-600[qctbyt : bfc] error:

     create table t3 as (select * from t2);

 

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.