title: Oracle ORA-00600
body: <p>I have SQL SELECT statement that returns:</p>
  
  <pre><code>    Error: ORA-00600: internal error code, arguments: [qerpfAllocateR], [], [], [], [], [], [], []
  </code></pre>
  
  <p>If I narrow my results by adding one more condition in WHERE clause everything is ok.</p>
  
  <p>Anyone knows what is happening?</p>
  
  <p>EDIT:</p>
  
  <pre><code>    select * from ( select tbl1.col1, ..., tbl1.points
      from table1 tbl1, table2 tbl2
      where tbl1.tbl2FK = tbl2.PK and
            tbl2.col1 = someNumber and
            tbl1.dateColumn = to_date('27-10-2008','dd-mm-yyyy')
      order by tbl1.points desc ) s where rownum &lt;= 3 
  </code></pre>
  
  <p>EDIT2:</p>
  
  <p>My DB admin suggested solution that works:</p>
  
  <pre><code>select * from (select rank() over (order by tbl1.points desc) rank,
                    tbl1.col1, ..., tbl1.points
             from table1 tbl1, table2 tbl2
             where tbl1.tbl2FK = tbl2.PK and
                   tbl2.col1 = someNumber and
                   tbl1.dateColumn = to_date('27-10-2008','dd-mm-yyyy')) s
       where s.rank &lt;= 3
  </code></pre>