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 to [Release 12.2]
Information in this document applies to any platform.


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);





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

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