title: "table or view does not exist"
body: <p>I am trying to create some tables but i get every time i try <code>table or view does not exist.</code> </p>
  
  <p>I cant find any solution. Here is my code.</p>
  
  <pre><code> CREATE
    TABLE "User"
    (
      anon_id      NUMBER (38) NOT NULL PRIMARY KEY,
      querytime    TIMESTAMP ,
      state_symbol VARCHAR2 (5) NOT NULL
    ) ;
  
  CREATE
    TABLE "state"
    (
      symbol            VARCHAR2 (5) NOT NULL PRIMARY KEY,
      name              VARCHAR2 (30 BYTE) ,
      "size"            NUMBER (38) ,
      population        NUMBER (38) ,
      tourists          NUMBER (38) 
    ) ;
  
  CREATE
    TABLE "population_goup"
    (
      name              VARCHAR2 (255) NOT NULL PRIMARY KEY,
      COUNT             NUMBER (38) 
    ) ;
  </code></pre>
  
  <p>The first 3 tables are createt and now he starts "table or view does not exist" and i dont know why.</p>
  
  <pre><code>CREATE TABLE "location"
    (
      zip         NUMBER (38) NOT NULL PRIMARY KEY,
      city        VARCHAR2 (30 BYTE) NOT NULL,
      state_symbol VARCHAR2 (30 BYTE) NOT NULL ,
      timezone    VARCHAR2 (30 BYTE) NOT NULL ,
      latitude    FLOAT ,
      longitude   FLOAT ,
      population  NUMBER (38) NOT NULL ,
      FOREIGN KEY (state_symbol) references state(symbol)
    ) ;
  
  CREATE
    TABLE landmark
    (
      name              VARCHAR2 (30 BYTE) NOT NULL PRIMARY KEY,
      tourists          NUMBER (38) NOT NULL ,
      location_zip      NUMBER (38) NOT NULL REFERENCES location (zip)
    ) ;
  
  
  CREATE
    TABLE event
    (
      name              VARCHAR2 (255) NOT NULL ,
      from_date         TIMESTAMP ,
      to_date           TIMESTAMP ,
      location_zip      NUMBER (38) NOT NULL REFERENCES location (zip)
    ) ;
  
  
  CREATE
    TABLE lives_in
    (
      population_goup_name VARCHAR2 (255) NOT NULL REFERENCES population_group(NAME),
      state_symbol         VARCHAR2 (5) NOT NULL REFERENCES state(SYMBOL),
      PRIMARY KEY(population_goup_name, state_symbol)
    ) ;
  
    CREATE
    TABLE "searchquery"
    (
      query        VARCHAR2 (4000 CHAR) NOT NULL PRIMARY KEY,
      User_id NUMBER (38) NOT NULL REFERENCES User(anon_id),
      state_symbol VARCHAR2 (5) REFERENCES state(symbol),
      population_name VARCHAR2 (255) REFERENCES population_goup(name),
      landmark_name  VARCHAR2 (30 BYTE) REFERENCES landmark(name),
      event_name  VARCHAR2 (255) REFERENCES event(name),
      location_zip NUMBER (38) REFERENCES landmark(zip)
    ) ;
  </code></pre>
  
  <p>For searchquery i get "invalid table name" but its not a reserved word so why?
  I cant find any help from the script of my uni so i thanks to every one that can help me!</p>