{"id":3074,"date":"2021-03-23T09:34:17","date_gmt":"2021-03-23T09:34:17","guid":{"rendered":"https:\/\/swiv.com.br\/installing-the-oracle-hr-schema\/"},"modified":"2026-05-27T20:02:50","modified_gmt":"2026-05-27T19:02:50","slug":"installing-the-oracle-hr-schema","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/03\/23\/installing-the-oracle-hr-schema\/","title":{"rendered":"Installing the Oracle HR Schema"},"content":{"rendered":"<p>Vou precisar realizar alguns testes usando apenas o schema sample HR, que \u00e9 fornecido pela Oracle, por\u00e9m, no momento que instalei meu ambiente, n\u00e3o habilitei a op\u00e7\u00e3o de instalar este e outros schemas na cria\u00e7\u00e3o do banco. Desse modo, farei a cria\u00e7\u00e3o manual, que \u00e9 descrita <a rel=\"\\&quot;noreferrer noopener\" noopener=\"\" href=\"https:\/\/docs.oracle.com\/database\/121\/COMSC\/installation.htm#COMSC00004\" target=\"\\&quot;_blank\\&quot;\">NESTE<\/a> documento da Oracle.<\/p>\n\n\n<p>Os scripts necess\u00e1rio est\u00e3o hospedados no diret\u00f3rio $ORACLE_HOME\/demo\/schema\/human_resources:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 human_resources]$ pwd\n\/oracle\/18.0.0\/product\/demo\/schema\/human_resources\n&#x5B;oracle@oel8 human_resources]$ ls -lthr\ntotal 100K\n-rw-r--r--. 1 oracle oinstall 1.4K Aug 29  2002 hr_idx.sql\n-rw-r--r--. 1 oracle oinstall 7.1K Aug 29  2002 hr_comnt.sql\n-rw-r--r--. 1 oracle oinstall 9.2K Aug 29  2002 hr_cre.sql\n-rw-r--r--. 1 oracle oinstall 2.7K Aug 29  2002 hr_code.sql\n-rw-r--r--. 1 oracle oinstall 1.2K Oct 12  2002 hr_analz.sql\n-rw-r--r--. 1 oracle oinstall  44K Aug 15  2008 hr_popul.sql\n-rw-r--r--. 1 oracle oinstall 5.0K Nov  6  2015 hr_main_new.sql\n-rw-r--r--. 1 oracle oinstall 2.6K Nov  6  2015 hr_drop_new.sql\n-rw-r--r--. 1 oracle oinstall 4.7K Mar 30  2016 hr_main.sql\n-rw-r--r--. 1 oracle oinstall 2.6K Mar 30  2016 hr_drop.sql\n&#x5B;oracle@oel8 human_resources]$\n<\/pre><\/div>\n\n\n<p>Executando o script &#8220;hr_main.sql&#8221; que faz todo o trabalho para n\u00f3s. Em tempo de execu\u00e7\u00e3o forneceremos a senha do schema HR, uma tablespace padr\u00e3o, uma tablespace tempor\u00e1ria e por fim um diret\u00f3rio absoluto para a cria\u00e7\u00e3o do log da opera\u00e7\u00e3o.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 human_resources]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 18.0.0.0.0 - Production on Tue Mar 23 06:30:10 2021\nVersion 18.13.0.0.0\n \nCopyright (c) 1982, 2018, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.13.0.0.0\n \nSQL&gt; @hr_main.sql\n \nspecify password for HR as parameter 1:\nEnter value for 1: oracle\n \nspecify default tablespeace for HR as parameter 2:\nEnter value for 2: USERS\n \nspecify temporary tablespace for HR as parameter 3:\nEnter value for 3: TEMP\n \nspecify log path as parameter 4:\nEnter value for 4: \/home\/oracle\n \n \nPL\/SQL procedure successfully completed.\n \n \nUser created.\n \n \nUser altered.\n \n \nUser altered.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nSession altered.\n \n \nSession altered.\n \n \nSession altered.\n \n******  Creating REGIONS table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n******  Creating COUNTRIES table ....\n \nTable created.\n \n \nTable altered.\n \n******  Creating LOCATIONS table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nSequence created.\n \n******  Creating DEPARTMENTS table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nSequence created.\n \n******  Creating JOBS table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n******  Creating EMPLOYEES table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable altered.\n \n \nSequence created.\n \n******  Creating JOB_HISTORY table ....\n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n******  Creating EMP_DETAILS_VIEW view ...\n \nView created.\n \n \nCommit complete.\n \n \nSession altered.\n \n******  Populating REGIONS table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating COUNTIRES table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating LOCATIONS table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating DEPARTMENTS table ....\n \nTable altered.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating JOBS table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating EMPLOYEES table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n******  Populating JOB_HISTORY table ....\n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \n1 row created.\n \n \nTable altered.\n \n \nCommit complete.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nCommit complete.\n \n \nProcedure created.\n \n \nTrigger created.\n \n \nTrigger altered.\n \n \nProcedure created.\n \n \nTrigger created.\n \n \nCommit complete.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nCommit complete.\n \n \nPL\/SQL procedure successfully completed.\n \nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Vemos que o schema foi criado com seus respectivos objetos:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSQL&gt; SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER=&#039;HR&#039;;\n \n  COUNT(*)\n----------\n        34\n \n1 row selected.\n<\/pre><\/div>\n\n\n<p>Arquivo de log criado:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel8 ~]$ cd \/home\/oracle\n&#x5B;oracle@oel8 ~]$ ls -lthr *hr*\n-rw-r--r--. 1 oracle oinstall 6.0K Mar 23 06:31 hr_main.log\n&#x5B;oracle@oel8 ~]$\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Vou precisar realizar alguns testes usando apenas o schema sample HR, que \u00e9 fornecido pela Oracle, por\u00e9m, no momento que instalei meu ambiente, n\u00e3o habilitei a op\u00e7\u00e3o de instalar este e outros schemas na cria\u00e7\u00e3o do banco. Desse modo, farei a cria\u00e7\u00e3o manual, que \u00e9 descrita NESTE documento da Oracle. Os scripts necess\u00e1rio est\u00e3o hospedados [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-3074","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=3074"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3074\/revisions"}],"predecessor-version":[{"id":9208,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3074\/revisions\/9208"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}