title: ORA-00904: invalid identifier, when column title is correct
body: <p>I have a large SQL query (15m runtime) <strong>created by someone else</strong> that I recently added a new column "SSBSECT_MAX_ENRL".  Now I'm getting an ORA-00904 error... But the name is correct and so is the table reference. </p>
  
  <p>In the "Long list of columns" nothing has been changed. There <em>no</em> are aliases with "quote marks", and all fields and commands are typed in CAPS LOCK characters. Just to double check, I removed the two new lines, and it ran just fine. </p>
  
  <p>The table DDEF_STAG.SSBSECT has 2 Keys, SSBSECT_TERM_CODE &amp; SSBSECT_CRN. I've quintuple checked the spelling of the field. "SSBSECT_MAX_ENRL" a P5 field.</p>
  
  <p>Doing some more digging, I realized the table is first truncated, the inserted into. Other steps in the query use DROP and CREATE. </p>
  
  <p>Any clues or suggestions?</p>
  
  <pre><code>TRUNCATE TABLE DDEF_STAG.SCR_DRIVER;
  (Drop all indexes)    
  INSERT INTO DDEF_STAG.SCR_DRIVER
      (
         (Long list of columns)
       **SSBSECT_MAX_ENRL**
      )
      SELECT 
       (Long list of columns)
        **DDEF_STAG.SSBSECT.SSBSECT_MAX_ENRL**
      FROM
        DDEF_STAG.STVRSTS,
        DDEF_STAG.STVTERM STVTERM2,
        DDEF_STAG.STVTERM,
        DDEF_STAG.SYRPRLE,
        DDEF_STAG.SCBCRSE_XREF,
        DDEF_STAG.SSBSECT,
        DDEF_STAG.SGBSTDN,
        DDEF_STAG.SGBSTDN_XREF,
        DDEF_STAG.SFRSTCR,
        DDEF_STAG.STUDENT_TOINCLUDE_DWH
      WHERE (giant list of criteria too long to list)
  (Recreate all indexes)  
  </code></pre>