Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Josh HolsteinAug 6 2021 — edited Aug 6 2021

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 .

Comments

Post Details

Added on Aug 6 2021
2 comments
567 views