My Oracle Support Banner

ORA-600[17090] When Creating a View with an Inner Join (Doc ID 2490023.1)

Last updated on MARCH 24, 2020

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Creating a view with a subquery that has an inner join on two ROWID columns from different views results in an ORA-600[17090] error:

SQL> create view TestView AS
  2  SELECT
  3    T.Id AS TestTableId
  4  FROM TestTable T
  5  WHERE EXISTS (
  6    SELECT * FROM View1 VW1
  7      INNER JOIN View2 VW2 ON (
  8        VW1.TestTableROWID = VW2.TestTableROWID));
FROM Report R
     *
ERROR at line 4:
ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], [], [], [], [], [], []

 

The Call Stack Trace in the associated incident trace file shows:

[10]: cvwdrv []<-- Signaling
[11]: opiexe [Time_Limit]
[12]: opiosq0 [OPI]
[13]: kpoal8 [PROGINT_MISC]
[14]: opiodr [OPI]
[15]: ttcpip []
[16]: opitsk [OPI]
[17]: opiino [OPI]
[18]: opiodr [OPI]

 

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
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.