/competitions-oracle

Ready-to-use database on the "Competitions" topic

Primary LanguagePLSQL

competitions-oracle

Oracle Database (xe-11g) schema with fake data to play with out-the-box.

Developed using docker image by @sath89.

Schema

Install

Via Docker

  1. Clone repository:

git clone https://github.com/maximillian2/competitions-oracle.git

cd competitions-oracle

  1. Get docker image from repository:

docker pull sath89/oracle-xe-11g

  1. Setup the database data storage (change /my/oracle/data/ to your database directory):
  docker run -d -p 8080:8080 -p 1521:1521 -v /my/oracle/data:/u01/app/oracle \
  -v `pwd`/:/mnt/ sath89/oracle-xe-11g
  1. Get docker processes:

docker ps

  1. Launch install script using instance name from previous command:

docker exec -it <docker image name> /bin/bash -c 'cd /mnt; install_competitions_schema.sh'

  1. Enter needed information about new user.

Local Oracle instance

  1. Clone repository:

git clone https://github.com/maximillian2/competitions-oracle.git

cd competitions-oracle

  1. Launch install script:

./install_competitions_schema.sh

Uninstall

Make sure user that is going to be deleted is disconnected from database!

Use -un or --uninstall argument:

./install_competitions_schema.sh --uninstall