ORA-00600 [qctbyt : bfc], ,  when running CTAS or create/compile view.
(Doc ID 2428701.1)
Last updated on OCTOBER 03, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.2]
Information in this document applies to any platform.
Attempting to run CTAS or CREATE VIEW the following error is raised:
The Call Stack Trace in the associated incident trace file shows:
<- 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.
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);
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