Help! Cannot create the database using HRSchema.sql provided by Oracle Sample Lab

Content

Dear all,

I completed the Autonomous_Database_Startup_Guide.pdf (attached) and moved onto the  Lab_4_Use_Oracle_Analytics_Cloud_Instance_to_create_Visualizations_from_an_Oracle_Autonomous_Database_Instance.pdf (attached).

When I ran the entire script, HRSchema.sql (attached as HRSchema.zip) to create the database by following the instructions on pages 8 and 9 of Lab 4 instructions, it generated the errors: ORA-00942: table or view does not exist (see the attached ORA-00942.jpg)

However, I could successfully create Table REGIONS and  Table COUNTRIES by executing the following SQLs one after another :

CREATE TABLE regions  
    ( region_id      NUMBER   
                     CONSTRAINT region_id_nn NOT NULL