title: Oracle insists that table or view does not exist, when it does
body: <p>Turns out this is entirely my bad, the table didn't exist (despite running the table creation code).</p>
  
  <p>I've run the following code, and get the following error:</p>
  
  <pre><code>CREATE TABLE Pathways (
      row_ID NUMBER(38,0) NOT NULL,
      pathway_Source_ID VARCHAR2(50 CHAR) NOT NULL, 
      pathway_Name VARCHAR2(200 CHAR) NOT NULL);
  
  CREATE UNIQUE INDEX mv_Pathway ON Pathways (pathway_Source_ID, pathway_Name);
  CREATE INDEX mv_Look ON Pathways (row_ID, pathway_Source_ID, pathway_Name);
  
  TRUNCATE TABLE Pathways;
  INSERT INTO Pathways 
    SELECT rownum, pathwaySourceID, pathwayName FROM (
      SELECT pathwaySourceID, pathwayName FROM Old_Pathways Order By pathwaySourceID, pathwayName);
  </code></pre>
  
  <p>The error:</p>
  
  <pre><code>Error report -
  SQL Error: ORA-00942: table or view does not exist
  00942. 00000 -  "table or view does not exist"
  </code></pre>
  
  <p>The "Error at Command line : Column" identifies the Pathways table as the problem.  The TRUNCATE TABLE call works just fine.  And if I run the select statement by itself it runs correctly, producing the output I want.</p>