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 126.96.36.199 to 188.8.131.52 [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:
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
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.
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