Forum Stats

  • 3,768,187 Users
  • 2,252,756 Discussions
  • 7,874,485 Comments

Discussions

Running a script to install HR schema objects using SQL Developer Web onto ATP database

User_OOHC8
User_OOHC8 Member Posts: 2 Green Ribbon
edited Aug 6, 2021 4:20PM in SQL Developer

Hi, I am a newbie to Oracle development but not new to SQL.

I want to execute some scripts to install the HR schema objects & data onto an ATP database using SQL Developer Web but can't find any info on how to execute the scripts. I have tried putting the full path and script file name in the Worksheet e.g.

C:\Users\yholstein\Downloads\db-sample-schemas-19.2\db-sample-schemas-19.2\human_resources\hr_cre.sql

and clicking the Run Script button but no success. I am able to execute SQL queries.

Any help would be appreciated,

thanks,

Josh Holstein .

Tagged:

Answers