title: Invalid FK and PK reference
body: <p>Unable to create table as oracle shows ' no matching unique or primary key for this column-list' when I did label the primary key reference for the required table.</p>
  
  <p>First table created successfully:</p>
  
  <pre><code>CREATE TABLE TEST
    (
      TESTno VARCHAR2(6) NOT NULL,
      ExamNo VARCHAR2(6) NOT NULL,
      TEST_Date DATE NOT NULL,
      ACTUAL DATE,
      PREDICTED Date,
      CONSTRAINT TESTPKs PRIMARY KEY (TEST_Date, TESTno, ExamNo),
      CONSTRAINT TTESTNO_Fk FOREIGN KEY (TESTno) REFERENCES TESTPAPER (Flightno)
      CONSTRAINT TEXAMNo_FK FOREIGN KEY (ExamNo) REFERENCES Exam (ExamNo)
    );
  </code></pre>
  
  <p>Here's the table i want to create and gives me error:</p>
  
  <pre><code>CREATE TABLE Assignment
    (
      TEST_Date DATE NOT NULL,
      ExamNo VARCHAR2(6) NOT NULL,
      TestNo VARCHAR2(6) NOT NULL,
      Type  VARCHAR2(20),
      Hours_Spent Decimal(4,2),
      CONSTRAINT ASSIGNPKS PRIMARY KEY (TEST_Date, TestNo , ExamNo),
      CONSTRAINT ASSIGNTESTDATE_FK FOREIGN KEY (TEST_Date) REFERENCES TEST(TEST_Date) ON
    DELETE CASCADE,
      CONSTRAINT ASSIGNTESTNO_FK FOREIGN KEY (TESTno) REFERENCES TESTPAPER (Flightno)
      CONSTRAINT TEXAMNo_FK FOREIGN KEY (ExamNo) REFERENCES Exam (ExamNo)
    );
  </code></pre>
  
  <p>May i know where's the issue that it keeps giving me no matching unique primary keys? I already tried to recreate and labelled the 'test_Date' as my primary key. But oracle can't seems to find.</p>
  
  <p>Thanks</p>