title: Simple SQL issues, cannot figure out what I'm doing wrong to get these errors - ORA-00942 / 907 / 922
body: <p>This is a supposed to be a simple SQL project, but I'm stuck on the first step. I've never worked with SQL before, so I'm pretty lost. Can someone please tell me what I did wrong that's causing these errors?</p>
  
  <p>Here is the file:</p>
  
  <pre><code>   SPOOL output.log;
  
      DROP TABLE rental CASCADE CONSTRAINTS;
  
      DROP TABLE movie CASCADE CONSTRAINTS;
  
      DROP TABLE customer CASCADE CONSTRAINTS;
  
      DROP TABLE distributor CASCADE CONSTRAINTS;
  
      DROP TABLE rental_store CASCADE CONSTRAINTS;
  
  
      CREATE TABLE rental (   
          inventory_id        CHAR(10)        PRIMARY KEY,
          transaction_id      CHAR(10)        NOT NULL UNIQUE,
          late                DECIMAL(6,2),
          damaged             DECIMAL(6,2),
          fail_rewind         DECIMAL(6,2),
          taxes               DECIMAL(6,2)    NOT NULL,
          discount            DECIMAL(6,2),
          customer_id         CHAR(10)        NOT NULL UNIQUE,
      CONTRAINT rental_FK FOREIGN KEY (customer_id) REFERENCES customer (customer_id));
  
      CREATE TABLE movie (    
          title_id_number     CHAR(10)        PRIMARY KEY,
          genre               VARCHAR2(20)    NOT NULL,
          actor               VARCHAR2(30)    NOT NULL, 
          director            VARCHAR2(30)    NOT NULL,
          awards              VARCHAR2(30),
          running_length      INTEGER         NOT NULL,
          rating              VARCHAR2(5)     NOT NULL,
          year_released       INTEGER         NOT NULL,
          media_type          CHAR(5)         NOT NULL,
          inventory_id        CHAR(10)        NOT NULL UNIQUE,
          title               VARCHAR2(30)    NOT NULL,
          distrib_serial      INTEGER         NOT NULL UNIQUE,
          cat_mov_id          CHAR(10)        NOT NULL UNIQUE));    
  
      CREATE TABLE customer ( 
          customer_id     CHAR(10)        PRIMARY KEY,
          name            VARCHAR2(30)    NOT NULL,
          address         VARCHAR2(50)    NOT NULL,
          tele_number     CHAR(10)        NOT NULL UNIQUE,
          rent_history    INTEGER         NOT NULL));
  
      CREATE TABLE distributor (
            distributor_name      VARCHAR2(30)    PRIMARY KEY,
            catalog               VARCHAR2(30)    NOT NULL,
            genres_offered        VARCHAR2(50)    NOT NULL));
  
      CREATE TABLE rental_store (
             store_name       VARCHAR2(30)    PRIMARY KEY,
             address          VARCHAR2(50)    NOT NULL,
             owner            VARCHAR2(30)    NOT NULL));
  
      SPOOL OFF;  
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/dTjdE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dTjdE.png" alt="Output from running it in Putty"></a>
  <a href="https://i.stack.imgur.com/vFB75.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vFB75.png" alt="Output part 2"></a></p>