Skip to Main Content

Oracle Database Discussions

Oracle 12c, ORA-00600 while creating mat.view

User_UCA6RMar 30 2022

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Error report:
SQL Error: ORA-00600: internal error code, arguments: [qkswcWithQbcRefdByMain4], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause: This is the generic internal error number for Oracle program
exceptions. This indicates that a process has encountered an
exceptional condition.
*Action: Report as a bug - the first argument is the internal error number
The code is:

create materialized view m_test
BUILD IMMEDIATE
REFRESH FORCE
ON DEMAND
ENABLE QUERY REWRITE
as
with
tab1 as (
select...
)
,tab2 as (select ...)
select .. from tab2
Is there any workaround?

Comments
Post Details
Added on Mar 30 2022
3 comments
71 views