title: create table statement resulted in "Failed: Warning: execution completed with warning" but no errors
body: <p>My SQL code ran, seemed to work, but gave me a warning yet I cannot find the details of the warning.</p>
  
  <p>I tried</p>
  
  <pre><code>    select * from user_errors and 
      select * from dba_errors and 
      select * from all_errors
  </code></pre>
  
  <p>When I did show errors, it said "No Errors."</p>
  
  <p>I saw this in more than one place, and each time it was when the table being created was large or at least was created from a large or complex select. For now, I'd like to learn where else these errors are shown. Maybe I can ignore it, but would like to see what Oracle's concern was before doing so.</p>
  
  <p>The SQL that fails is a create as select statement, I think notable is that the select could could contain millions of rows. I understand Oracle only allows DDL statements outside of PL/SQL (begin/end) blocks for a reason that I do not understand.  Nonetheless, I'd like to know if I'd get the same warning outside of PL/SQL as I would inside a PL/SQL block.</p>
  
  <p>So, I need to be clear, the statement that failed was something like</p>
  
  <pre><code>CREATE TABLE USAGE_COUNT as (
      SELECT* FROM SOME_REALLY_LARGE_TABLE_1 T1
      LEFT JOIN SOME_OTHER_MEDIUM_SIZED_TABLE_2 T2
      ON T1.ID = T2.ID
  </code></pre>
  
  <p>I really wish I could share the exact SQL, but I don't know how much I could get away with and I want to keep my job. But in this case, I'm not asking for specifics on how to fix the error or warning, only specifics on how to get the actual warning.</p>
  
  <p>So to be clear, the statement that causes the warning is executed completely outside of any PL/SQL, and is directly invoked using SQLDeveloper in the worksheet. I do, however, have PL/SQL that I'm also writing, and I'd like to know where the error would show up had it occurred there as well. </p>