title: Trouble creating foreign key in Oracle create table
body: <p>I'm building some really simple tables in Oracle and I'm having trouble creating foreign keys.  The fac_ID in Equipment is the FK that references fac_ID in faculty, but it is creating an error.</p>
  
  <p>I'm using Oracle 11g Express.  When I run "select * from equipment" it produces the error " ORA-00942: table or view does not exist"</p>
  
  <pre><code>CREATE TABLE Faculty(
  fac_ID        VARCHAR(10)    NOT NULL,
  fac_Street    VARCHAR(70)    NOT NULL,
  fac_City    VARCHAR(30)    NOT NULL,
  fac_PROV    VARCHAR(2)    NOT NULL,
  fac_Phone    VARCHAR(12)    NOT NULL,
  PRIMARY KEY (fac_ID)
  ); 
  
  CREATE TABLE Equipment(
  equip_ID        VARCHAR(10)    NOT NULL,
  fac_ID            VARCHAR(10)    NOT NULL,
  equip_Name       VARCHAR(50)    NOT NULL,
  equip_Quantity    VARCHAR(3)    NOT NULL,
  equip_Purchase_Date    DATE    NOT NULL,
  PRIMARY KEY (equip_ID),
  CONSTRAINT fac_ID FOREIGN KEY (fac_ID) REFERENCES Faculty(fac_ID) 
  ); 
  </code></pre>