Help! Cannot create the database using HRSchema.sql provided by Oracle Sample Lab
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