Hello,
I'm new to using oracle developer data modeler and oracle apex and I have very little knowledge of DB, so I apologize if I make big mistakes.
context: I recently started a course in DB management and I have to realize for a lab an application on apex allowing to access several tables and to add / modify / search data.
So I made a logical model on data modeler then I regenerate the physical model.
here is what i get


I then generated the sql script by exporting a ddl file with all my tables, here is what I get
-- Généré par Oracle SQL Developer Data Modeler 19.4.0.350.1424
-- à : 2020-05-14 03:40:44 EEST
-- site : Oracle Database 11g
-- type : Oracle Database 11g
CREATE TABLE actors (
actors\_id INTEGER NOT NULL,
actors\_firstname VARCHAR2(255 CHAR),
actors\_lastname VARCHAR2(255 CHAR),
actors\_date\_of\_birth DATE,
actors\_nationality VARCHAR2(255 CHAR)
);
ALTER TABLE actors ADD CONSTRAINT actors_pk PRIMARY KEY ( actors_id );
CREATE TABLE directors (
directors\_id INTEGER NOT NULL,
directors\_fistname VARCHAR2(255 CHAR),
directors\_lastname VARCHAR2(255 CHAR),
directors\_date\_of\_birth DATE,
directors\_nationality VARCHAR2(255 CHAR)
);
ALTER TABLE directors ADD CONSTRAINT directors_pk PRIMARY KEY ( directors_id );
CREATE TABLE distributors (
distributors\_id INTEGER NOT NULL,
distributors\_name VARCHAR2(255 CHAR),
distributors\_country VARCHAR2(255 CHAR)
);
ALTER TABLE distributors ADD CONSTRAINT distributors_pk PRIMARY KEY ( distributors_id );
CREATE TABLE genre (
genre\_id INTEGER NOT NULL,
genre\_genre VARCHAR2(255 CHAR)
);
ALTER TABLE genre ADD CONSTRAINT genre_pk PRIMARY KEY ( genre_id );
CREATE TABLE movie (
attribute\_1 INTEGER NOT NULL,
movie\_year DATE,
movie\_title VARCHAR2(255 CHAR),
movie\_length INTEGER
);
ALTER TABLE movie ADD CONSTRAINT movie_pk PRIMARY KEY ( attribute_1 );
CREATE TABLE "Movie/Actors" (
movie\_attribute\_1 INTEGER NOT NULL,
actors\_actors\_id INTEGER NOT NULL
);
ALTER TABLE "Movie/Actors" ADD CONSTRAINT "Movie/Actors_PK" PRIMARY KEY ( movie_attribute_1,
actors\_actors\_id );
CREATE TABLE "Movie/Directors" (
movie\_attribute\_1 INTEGER NOT NULL,
directors\_directors\_id INTEGER NOT NULL
);
ALTER TABLE "Movie/Directors" ADD CONSTRAINT "Movie/Directors_PK" PRIMARY KEY ( movie_attribute_1,
directors\_directors\_id );
CREATE TABLE "Movie/Distributor" (
movie\_attribute\_1 INTEGER NOT NULL,
distributors\_distributors\_id INTEGER NOT NULL
);
ALTER TABLE "Movie/Distributor" ADD CONSTRAINT "Movie/Distributor_PK" PRIMARY KEY ( movie_attribute_1,
distributors\_distributors\_id );
CREATE TABLE "Movie/Genre" (
movie\_attribute\_1 INTEGER NOT NULL,
genre\_genre\_id INTEGER NOT NULL
);
ALTER TABLE "Movie/Genre" ADD CONSTRAINT "Movie/Genre_PK" PRIMARY KEY ( movie_attribute_1,
genre\_genre\_id );
ALTER TABLE "Movie/Actors"
ADD CONSTRAINT "Movie/Actors\_Actors\_FK" FOREIGN KEY ( actors\_actors\_id )
REFERENCES actors ( actors\_id );
ALTER TABLE "Movie/Actors"
ADD CONSTRAINT "Movie/Actors\_Movie\_FK" FOREIGN KEY ( movie\_attribute\_1 )
REFERENCES movie ( attribute\_1 );
ALTER TABLE "Movie/Directors"
ADD CONSTRAINT "Movie/Directors\_Directors\_FK" FOREIGN KEY ( directors\_directors\_id )
REFERENCES directors ( directors\_id );
ALTER TABLE "Movie/Directors"
ADD CONSTRAINT "Movie/Directors\_Movie\_FK" FOREIGN KEY ( movie\_attribute\_1 )
REFERENCES movie ( attribute\_1 );
ALTER TABLE "Movie/Distributor"
ADD CONSTRAINT "Movie/Distrib\_FK" FOREIGN KEY ( distributors\_distributors\_id )
REFERENCES distributors ( distributors\_id );
ALTER TABLE "Movie/Distributor"
ADD CONSTRAINT "Movie/Distrib\_Movie\_FK" FOREIGN KEY ( movie\_attribute\_1 )
REFERENCES movie ( attribute\_1 );
ALTER TABLE "Movie/Genre"
ADD CONSTRAINT "Movie/Genre\_Genre\_FK" FOREIGN KEY ( genre\_genre\_id )
REFERENCES genre ( genre\_id );
ALTER TABLE "Movie/Genre"
ADD CONSTRAINT "Movie/Genre\_Movie\_FK" FOREIGN KEY ( movie\_attribute\_1 )
REFERENCES movie ( attribute\_1 );
-- Rapport récapitulatif d'Oracle SQL Developer Data Modeler :
--
-- CREATE TABLE 9
-- CREATE INDEX 0
-- ALTER TABLE 17
-- CREATE VIEW 0
-- ALTER VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- CREATE MATERIALIZED VIEW LOG 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ORDS DROP SCHEMA 0
-- ORDS ENABLE SCHEMA 0
-- ORDS ENABLE OBJECT 0
--
-- ERRORS 0
-- WARNINGS 0
once this done, i was on apex> utilities> quick sql and pasted my sql script
however, once the sql is generated and saved, when I try to review and run the script the following error appears:

I searched the net and I did not find an answer correcting my error (maybe I was looking badly)
if anyone would know how to fix this error it would help me a lot