1

I am trying to manually install HR schema in my oracle environment by following the steps specified by oracle Help Center (11.2). Web link: https://docs.oracle.com/cd/E11882_01/server.112/e10831/installation.htm#COMSC001
However, I have run into some problems. It is specified that I only need to call hr_main.sql script (located in human_resources directory)using this command @?/demo/schema/human_resources/hr_main.sql.
My human_resources has only a script named hr_code and when I run it I do not get any type of installation procedure (entering password, tablespace etc as oracle specifies in the procedure).
Any help as well as other possible solutions would be very much appreciated.
Alternatively, could it be more feasible if I created a new database using database configuration assistant (thus installing the schemas during the installation procedure itself)?

0

Manually Installing Sample Schemas

Install Oracle Database Examples (Companion CD, part of the media kit) to include these scripts in the demo directory under $ORACLE_HOME.

The scripts for installing sample schemas is a seperate download and they are not installed by default.

Download Oracle Database Examples

Follow the instructions there.

0

Oracle has them on GitHub.

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

They also have the scripts for LiveSQL userd.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.