Manually installing sample schemas in Oracle 11g

Question

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)?

Answer 1

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.

• Bendemann: Hey, thanks for the suggestion. I am following it, but the oracle link to download Oracle Database Examples zip file (from [link]oracle.com/technetwork/database/enterprise-edition/downloads/…) is broken.
• Balazs Papp: @Bendemann The link here is not broken: oracle.com/technetwork/database/enterprise-edition/downloads/…

Answer 2

Oracle has them on GitHub.

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

They also have the scripts for LiveSQL userd.