title: ORA-00600 when Creating Materialized View
body: <p>I'm trying to create a materialized view like using the following:</p>
  <pre><code>CREATE MATERIALIZED VIEW orders_mv AS
    SELECT *
    FROM (SELECT * FROM table1
          UNION
          SELECT * FROM table2
          ORDER BY DBMS_RANDOM.VALUE)
    WHERE rownum &lt;= 5;
  </code></pre>
  <p>But it gives me an ORA-00600 and disconnects me with the usual disconnect error:</p>
  <pre><code>CREATE MATERIALIZED VIEW orders_mv
                     *
  ERROR at line 1:
  ORA-03113: end-of-file on communication channel
  Process ID: 89299
  Session ID: 11416 Serial number: 40331
  </code></pre>
  <p>We are running Oracle 12c.   Is there some bug with creating a materialized view and using an order by clause in this fashion?</p>