In this step we pull the ready-made Oracle 19c schema repository from the Github location and dump it into the local volume. This repository contains a copy of the Oracle Database sample schemas that are installed with Oracle Database Enterprise Edition. From the repository, we import the HR schema into the Oracle 19c database by running the script @mksample. 

To pull the sample schemas from GitHub, do the following:

1. Import sample schemas.

[root@12c-docker ~] # git clone https://github.com/oracle/db-sample-schemas.git

2. Copy these sample schemas to the Docker volume that is accessible to the container.

[root@12c-docker oracle_sample_schema] # cp -R db-sample-schemas/ /home/oracle/

3. Modify the folder path inside the scripts to what it is inside the container. For example:

[root@12c-docker db-sample-schemas] # perl -p -i.bak -e 's#__SUB__CWD__#'/opt/oracle/oradata/db-sample-schemas'#g' *.sql */*.sql */*.dat

4. Run the script “mksample” in the container to create sample schemas inside the database. Provide the credentials for sys, system users, and all other schemas when prompted.

sql>alter session set container=ORCLPDB1;

sql>@mksample