Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to import sample schemas to oracle database in docker container through SQL Developer?

My system is MAC .I don't have oracle database installed in my system .I have oracle database running in docker container in my system .I have SQL Developer installed and I can connect to the database though it . How would I import oracle sample schemas in the database through SQL Developer.i have sample schemas "source code (tar.gz)"downloaded from the below link

https://github.com/oracle/db-sample-schemas/releases

like image 675
Lucky1234 Avatar asked Oct 25 '25 13:10

Lucky1234


1 Answers

Read the readme in the Zip

enter image description here

If you want to use SQL Developer and it's GUI, pick a schema in the archive, like Human Resources (HR), and use the .sql files.

Open the hr_main.sql file, set your editor to an Administrator level user, and run the the script in a SQL Worksheet using the F5 (execute as script) button.

enter image description here

You'll have some questions to answer.

like image 73
thatjeffsmith Avatar answered Oct 28 '25 02:10

thatjeffsmith



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!