Q: Can't input data into tables (Oracle 12c) Sorry in advance for the large question, but I'm working on a piece of coursework for a data management module using Oracle 12c, I don't have any prior experience in anything like this and I'm very confused as to what to do. The objective is to create a database for a fictional shipping company, I have created an ERD and exported that into a DDL to use for my database queries. I have been able to input data into the Ship table, however when I try to input data into any other tables it come up with Error ORA-00942: table or view does not exist, and I am unsure why. Below is the code exported from the DDL and some sample statements. Thank you in advance for any help that you can give.
CREATE TABLE Consignments
(
Consignment_Number CHAR (6 CHAR) NOT NULL ,
Supplier_Address   VARCHAR2 (40 CHAR) ,
Delivery_Address   VARCHAR2 (40 CHAR) ,
Volume             NUMBER ,
Weight             NUMBER ,
Ship_Ship_Number   CHAR (4 CHAR) NOT NULL
) ;
ALTER TABLE Consignments ADD CONSTRAINT Consignments_PK PRIMARY KEY ( 
Consignment_Number ) ;

CREATE TABLE Officers
(
Officer_Number            CHAR (6 CHAR) NOT NULL ,
Officer_Name              VARCHAR2 (20 CHAR) ,
Officer_Address           VARCHAR2 (40 CHAR) ,
Officer_DoB               DATE ,
Officer_Rank              VARCHAR2 (20 CHAR) ,
Ship_Ship_Number          CHAR (4 CHAR) NOT NULL ,
Officers_Officer_Number   CHAR (6 CHAR) ,
Officers_Ship_Ship_Number CHAR (4 CHAR)
) ;
ALTER TABLE Officers ADD CONSTRAINT Officers_PK PRIMARY KEY ( 
Officer_Number, Ship_Ship_Number ) ;

CREATE TABLE Port
(
Port_Number    CHAR (3 CHAR) NOT NULL ,
Port_Name      VARCHAR2 (20 CHAR) ,
Agent_Name     VARCHAR2 (20 CHAR) ,
Arrival_Date   DATE ,
Departure_Date DATE
) ;
ALTER TABLE Port ADD CONSTRAINT Port_PK PRIMARY KEY ( Port_Number ) ;

CREATE TABLE Relation_1
(
Voyage_Voyage_Number CHAR (6 CHAR) NOT NULL ,
Port_Port_Number     CHAR (3 CHAR) NOT NULL
) ;
ALTER TABLE Relation_1 ADD CONSTRAINT Relation_1_PK PRIMARY KEY ( 
Voyage_Voyage_Number, Port_Port_Number ) ;

CREATE TABLE Ship
(
Ship_Number          CHAR (4 CHAR) NOT NULL ,
Ship_Name            CHAR (20 CHAR) ,
Voyage_Voyage_Number CHAR (6 CHAR) NOT NULL
) ;
CREATE UNIQUE INDEX Ship__IDX ON Ship
(
Voyage_Voyage_Number ASC
)
;
ALTER TABLE Ship ADD CONSTRAINT Ship_PK PRIMARY KEY ( Ship_Number ) ;

CREATE TABLE Voyage
(
Voyage_Number    CHAR (6 CHAR) NOT NULL ,
Duration         NUMBER ,
Ship_Ship_Number CHAR (4 CHAR) NOT NULL
) ;
CREATE UNIQUE INDEX Voyage__IDX ON Voyage
(
Ship_Ship_Number ASC
)
;
ALTER TABLE Voyage ADD CONSTRAINT Voyage_PK PRIMARY KEY ( Voyage_Number ) ;

ALTER TABLE Consignments ADD CONSTRAINT Consignments_Ship_FK FOREIGN KEY ( 
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;

ALTER TABLE Relation_1 ADD CONSTRAINT FK_ASS_1 FOREIGN KEY ( 
Voyage_Voyage_Number ) REFERENCES Voyage ( Voyage_Number ) ;

ALTER TABLE Relation_1 ADD CONSTRAINT FK_ASS_2 FOREIGN KEY ( 
Port_Port_Number ) REFERENCES Port ( Port_Number ) ;

ALTER TABLE Officers ADD CONSTRAINT Officers_Officers_FK FOREIGN KEY ( 
Officers_Officer_Number, Officers_Ship_Ship_Number ) REFERENCES Officers ( 
Officer_Number, Ship_Ship_Number ) ;

ALTER TABLE Officers ADD CONSTRAINT Officers_Ship_FK FOREIGN KEY ( 
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;

ALTER TABLE Ship ADD CONSTRAINT Ship_Voyage_FK FOREIGN KEY ( 
Voyage_Voyage_Number ) REFERENCES Voyage ( Voyage_Number ) ;

ALTER TABLE Voyage ADD CONSTRAINT Voyage_Ship_FK FOREIGN KEY ( 
Ship_Ship_Number ) REFERENCES Ship ( Ship_Number ) ;




INSERT INTO Officers (Officer_Number, Officer_Name, Officer_Address, 
Officer_DoB, Officer_Rank, Ship_Ship_Number)
VALUES (000000, 'J. Cena', ('1 Elder Row, Glasgow'), 1970-01-01, 'Captain', 
1111)

