Installing the Oracle HR Schema

Administration / 14/07/2022

Vou precisar realizar alguns testes usando apenas o schema sample HR, que é fornecido pela Oracle, porém, no momento que instalei meu ambiente, não habilitei a opção de instalar este e outros schemas na criação do banco. Desse modo, farei a criação manual, que é descrita NESTE documento da Oracle.

Os scripts necessário estão hospedados no diretório $ORACLE_HOME/demo/schema/human_resources:

[oracle@oel8 human_resources]$ pwd
/oracle/18.0.0/product/demo/schema/human_resources
[oracle@oel8 human_resources]$ ls -lthr
total 100K
-rw-r--r--. 1 oracle oinstall 1.4K Aug 29  2002 hr_idx.sql
-rw-r--r--. 1 oracle oinstall 7.1K Aug 29  2002 hr_comnt.sql
-rw-r--r--. 1 oracle oinstall 9.2K Aug 29  2002 hr_cre.sql
-rw-r--r--. 1 oracle oinstall 2.7K Aug 29  2002 hr_code.sql
-rw-r--r--. 1 oracle oinstall 1.2K Oct 12  2002 hr_analz.sql
-rw-r--r--. 1 oracle oinstall  44K Aug 15  2008 hr_popul.sql
-rw-r--r--. 1 oracle oinstall 5.0K Nov  6  2015 hr_main_new.sql
-rw-r--r--. 1 oracle oinstall 2.6K Nov  6  2015 hr_drop_new.sql
-rw-r--r--. 1 oracle oinstall 4.7K Mar 30  2016 hr_main.sql
-rw-r--r--. 1 oracle oinstall 2.6K Mar 30  2016 hr_drop.sql
[oracle@oel8 human_resources]$

Executando o script “hr_main.sql” que faz todo o trabalho para nós. Em tempo de execução forneceremos a senha do schema HR, uma tablespace padrão, uma tablespace temporária e por fim um diretório absoluto para a criação do log da operação.

[oracle@oel8 human_resources]$ sqlplus / as sysdba
 
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 23 06:30:10 2021
Version 18.13.0.0.0
 
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.13.0.0.0
 
SQL> @hr_main.sql
 
specify password for HR as parameter 1:
Enter value for 1: oracle
 
specify default tablespeace for HR as parameter 2:
Enter value for 2: USERS
 
specify temporary tablespace for HR as parameter 3:
Enter value for 3: TEMP
 
specify log path as parameter 4:
Enter value for 4: /home/oracle
 
 
PL/SQL procedure successfully completed.
 
 
User created.
 
 
User altered.
 
 
User altered.
 
 
Grant succeeded.
 
 
Grant succeeded.
 
 
Session altered.
 
 
Session altered.
 
 
Session altered.
 
******  Creating REGIONS table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
******  Creating COUNTRIES table ....
 
Table created.
 
 
Table altered.
 
******  Creating LOCATIONS table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
 
Sequence created.
 
******  Creating DEPARTMENTS table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
 
Sequence created.
 
******  Creating JOBS table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
******  Creating EMPLOYEES table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
 
Table altered.
 
 
Sequence created.
 
******  Creating JOB_HISTORY table ....
 
Table created.
 
 
Index created.
 
 
Table altered.
 
******  Creating EMP_DETAILS_VIEW view ...
 
View created.
 
 
Commit complete.
 
 
Session altered.
 
******  Populating REGIONS table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating COUNTIRES table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating LOCATIONS table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating DEPARTMENTS table ....
 
Table altered.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating JOBS table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating EMPLOYEES table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
******  Populating JOB_HISTORY table ....
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
1 row created.
 
 
Table altered.
 
 
Commit complete.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Index created.
 
 
Commit complete.
 
 
Procedure created.
 
 
Trigger created.
 
 
Trigger altered.
 
 
Procedure created.
 
 
Trigger created.
 
 
Commit complete.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Comment created.
 
 
Commit complete.
 
 
PL/SQL procedure successfully completed.
 
SQL>

Vemos que o schema foi criado com seus respectivos objetos:

SQL> SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER='HR';
 
  COUNT(*)
----------
        34
 
1 row selected.

Arquivo de log criado:

[oracle@oel8 ~]$ cd /home/oracle
[oracle@oel8 ~]$ ls -lthr *hr*
-rw-r--r--. 1 oracle oinstall 6.0K Mar 23 06:31 hr_main.log
[oracle@oel8 ~]$

Leave a Comment

Your email address will not be published.

pt Portuguese
en Englishpt Portuguesees Spanish