I downloaded the Oracle DB Developer VM a while back and successfully created a new connection to connect to this VM in my SQLDeveloper app. Currently this connection only has HR schema and I would like to install another Oracle schema from this Github link to the existing connection.
As you can see in the README.md file (from the provided link) it says that I need to connect as privileged user with rights to create another user (SYSTEM, ADMIN, etc.)
.
How do I connect to the existing connection containing the HR schema as an admin/system user to run the sql files? I am logged in as 'HR' user in the existing connection and thus - as expected - I got ORA-01031 insufficient privileges
error when I tried to run any of the sql files in the SQLDeveloper app.
I am finally able to login as sys (please set the role = SYSDBA) in Sql Developer by creating a new connection - thanks to MTO for the tip!