{"id":3497,"date":"2021-04-03T09:22:00","date_gmt":"2021-04-03T09:22:00","guid":{"rendered":"https:\/\/swiv.com.br\/installing-oracle-19c-sample-schemas-manually\/"},"modified":"2026-05-27T20:02:33","modified_gmt":"2026-05-27T19:02:33","slug":"installing-oracle-19c-sample-schemas-manually","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/04\/03\/installing-oracle-19c-sample-schemas-manually\/","title":{"rendered":"Installing Oracle 19C Sample Schemas manually"},"content":{"rendered":"\n<p>Precisava criar o schema OE para um laborat\u00f3rio espec\u00edfico, mas percebi que n\u00e3o o tinha em meu banco de dados, mas que tamb\u00e9m n\u00e3o possu\u00eda o seu script de cria\u00e7\u00e3o no bin\u00e1rio instalado (vers\u00e3o 19C):<\/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@fornix1 schema]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 3 05:12:04 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; SELECT COUNT(*) FROM DBA_USERS WHERE USERNAME=&#039;OE&#039;;\n \n  COUNT(*)\n----------\n         0\n \nSQL&gt; !pwd\n\/oracle\/19.3.0\/product\/demo\/schema\n \nSQL&gt; !ls -lthr\ntotal 68K\n-rw-r--r--. 1 oracle oinstall 2.3K Apr  3  2009 drop_sch.sql\n-rw-r--r--. 1 oracle oinstall  17K Jun 30  2014 sted_mkplug.sql.dbl\n-rw-r--r--. 1 oracle oinstall  27K Jun 30  2014 mkplug.sql\n-rw-r-----. 1 oracle oinstall 1.7K Nov  5  2015 mk_dir.sql.sbs\ndrwxr-xr-x. 2 oracle oinstall 4.0K Apr 17  2019 human_resources\ndrwxr-xr-x. 2 oracle oinstall 4.0K Apr 17  2019 log\n-rw-r--r--. 1 oracle oinstall 1.8K Apr 27  2020 mk_dir.sql\n<\/pre><\/div>\n\n\n<p>Lendo a documenta\u00e7\u00e3o da Oracle, percebi que a partir da release 12.2, apenas o script do schema HR est\u00e1 dispon\u00edvel nos bin\u00e1rios. Todo o resto deve ser capturado do Github da Oracle:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-242.png\" alt=\"\" class=\"wp-image-7936\"\/><figcaption>Acessando o Git e baixando o arquivo. Link\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/github.com\/oracle\/db-sample-schemas\/releases\" target=\"_blank\">AQUI<\/a>.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-244.png\" alt=\"\" class=\"wp-image-7939\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/swiv.com.br\/wp-content\/uploads\/2022\/07\/image-245.png\" alt=\"\" class=\"wp-image-7940\"\/><\/figure>\n\n\n\n<p>Descompactando:<\/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@fornix1 ~]$ pwd\n\/home\/oracle\n&#x5B;oracle@fornix1 ~]$ unzip -d \/oracle\/19.3.0\/product\/demo\/schema db-sample-schemas-19c.zip\nArchive:  db-sample-schemas-19c.zip\n004d5f3c99dd2e19dee8b72360b55afce458ea32\n   creating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/CONTRIBUTING.md\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/LICENSE.md\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/README.md\n \n...\n \n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/shipping\/qs_main.sql\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/shipping\/qs_os.sql\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/shipping\/qs_run.sql\n  inflating: \/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/shipping\/qs_ws.sql\n&#x5B;oracle@fornix1 ~]$\n<\/pre><\/div>\n\n\n<p>Ap\u00f3s isso, basta entrar na pasta devida e executar o script oe_main.sql:<\/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@fornix1 order_entry]$ pwd\n\/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/order_entry\n&#x5B;oracle@fornix1 order_entry]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 3 05:25:47 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; @oe_main.sql\n \nspecify password for OE as parameter 1:\nEnter value for 1: oracle\n \nspecify default tablespeace for OE as parameter 2:\nEnter value for 2: USERS\n \nspecify temporary tablespace for OE as parameter 3:\nEnter value for 3: TEMP\n \nspecify password for HR as parameter 4:\nEnter value for 4: oracle\n \nspecify password for SYS as parameter 5:\nEnter value for 5: oracle\n \nspecify directory path for the data files as parameter 6:\nEnter value for 6: +DG_DATA\n \nwriteable directory path for the log files as parameter 7:\nEnter value for 7: \/home\/oracle\n \nspecify version as parameter 8:\nEnter value for 8: 19\n \nspecify connect string as parameter 9:\nEnter value for 9: CORTEX\n \nSP2-0606: Cannot create SPOOL file &quot;\/home\/oracleoe_oc_19.log&quot;\nDROP USER oe CASCADE\n          *\nERROR at line 1:\nORA-01918: user &#039;OE&#039; does not exist\n \n \nold   1: CREATE USER oe IDENTIFIED BY &amp;amp;pass\nnew   1: CREATE USER oe IDENTIFIED BY oracle\n \nUser created.\n \nold   1: ALTER USER oe DEFAULT TABLESPACE &amp;amp;tbs QUOTA UNLIMITED ON &amp;amp;tbs\nnew   1: ALTER USER oe DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS\n \nUser altered.\n \nold   1: ALTER USER oe TEMPORARY TABLESPACE &amp;amp;ttbs\nnew   1: ALTER USER oe TEMPORARY TABLESPACE TEMP\n \nUser altered.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \nConnected.\n \nGrant succeeded.\n \nConnected.\n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \nConnected.\n \nSession altered.\n \n \nSession altered.\n \nSP2-0310: unable to open file &quot;__SUB__CWD__\/order_entry\/coe_19.sql&quot;\nSP2-0310: unable to open file &quot;__SUB__CWD__\/order_entry\/loe_19.sql&quot;\nSP2-0310: unable to open file &quot;__SUB__CWD__\/order_entry\/poe_19.sql&quot;\nSP2-0310: unable to open file &quot;__SUB__CWD__\/order_entry\/oc_main.sql&quot;\nSP2-0310: unable to open file &quot;__SUB__CWD__\/order_entry\/oe_analz.sql&quot;\nConnected.\n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \nnot spooling currently\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Notei alguns erros reportados, por conta de um diret\u00f3rio n\u00e3o identificado, nesta etapa do script:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDEFINE vscript = __SUB__CWD__\/order_entry\/coe_&amp;amp;vrs\n@&amp;amp;vscript &amp;amp;vrs &amp;amp;pass &amp;amp;pass_sys &amp;amp;connect_string\n<\/pre><\/div>\n\n<p>Gra\u00e7as a um artigo do Tim Hall (<a rel=\"\\&quot;noreferrer noopener\" noopener=\"\" href=\"https:\/\/oracle-base.com\/articles\/misc\/install-sample-schemas\" target=\"\\&quot;_blank\\&quot;\">AQUI<\/a>), vi que caso o nosso diret\u00f3rio seja diferente do definido dentro do script, devemos executar o comando abaixo:<\/p>\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@fornix1 db-sample-schemas-19c]$ cd $ORACLE_HOME\/demo\/schema\/db-sample-schemas-19c\n&#x5B;oracle@fornix1 db-sample-schemas-19c]$ perl -p -i.bak -e &#039;s#__SUB__CWD__#&#039;$(pwd)&#039;#g&#039; *.sql *\/*.sql *\/*.dat\n&#x5B;oracle@fornix1 db-sample-schemas-19c]$\n<\/pre><\/div>\n\n\n<p>Vou dropar o schema que havia sido criado sem seus objetos:<\/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@fornix1 db-sample-schemas-19c]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 3 06:16:36 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; DROP USER OE CASCADE;\n \nUser dropped.\n<\/pre><\/div>\n\n\n<p>Executando novamente a cria\u00e7\u00e3o do OE:<\/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@fornix1 order_entry]$ pwd\n\/oracle\/19.3.0\/product\/demo\/schema\/db-sample-schemas-19c\/order_entry\n&#x5B;oracle@fornix1 order_entry]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 3 10:00:42 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; @oe_main.sql\n \nspecify password for OE as parameter 1:\nEnter value for 1: oracle\n \nspecify default tablespeace for OE as parameter 2:\nEnter value for 2: USERS\n \nspecify temporary tablespace for OE as parameter 3:\nEnter value for 3: TEMP\n \nspecify password for HR as parameter 4:\nEnter value for 4: oracle\n \nspecify password for SYS as parameter 5:\nEnter value for 5: oracle\n \nspecify directory path for the data files as parameter 6:\nEnter value for 6: +DG_DATA\n \nwriteable directory path for the log files as parameter 7:\nEnter value for 7: \/home\/oracle\n \nspecify version as parameter 8:\nEnter value for 8: v3\n \nspecify connect string as parameter 9:\nEnter value for 9: CORTEX\n \nSP2-0606: Cannot create SPOOL file &quot;\/home\/oracleoe_oc_v3.log&quot;\nDROP USER oe CASCADE\n          *\nERROR at line 1:\nORA-01918: user &#039;OE&#039; does not exist\n \n \nold   1: CREATE USER oe IDENTIFIED BY &amp;amp;pass\nnew   1: CREATE USER oe IDENTIFIED BY oracle\n \nUser created.\n \nold   1: ALTER USER oe DEFAULT TABLESPACE &amp;amp;tbs QUOTA UNLIMITED ON &amp;amp;tbs\nnew   1: ALTER USER oe DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS\n \nUser altered.\n \nold   1: ALTER USER oe TEMPORARY TABLESPACE &amp;amp;ttbs\nnew   1: ALTER USER oe TEMPORARY TABLESPACE TEMP\n \nUser altered.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \nConnected.\n \nGrant succeeded.\n \nConnected.\n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \nConnected.\n \nSession altered.\n \n \nSession altered.\n \n \nspecify Sample Schema version as parameter 1:\n \nspecify password for OE as parameter 2:\n \nPROMPT password for SYS as parameter 3:\n \nspecify connect string as parameter 4:\n \n \nType created.\n \n \nType created.\n \n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTrigger created.\n \n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable created.\n \n \nTable altered.\n \n \nTable created.\n \n \nIndex created.\n \n \nTable altered.\n \n \nTable created.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nTable altered.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSequence created.\n \n \nspecify password for OE as parameter 1:\n \nPROMPT password for SYS as parameter 2:\n \nspecify connect string as parameter 3:\n \nConnected.\n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nGrant succeeded.\n \n \nView created.\n \n \nView created.\n \n \nGrant succeeded.\n \n \nSession altered.\n \n \nPackage created.\n \n \nWarning: Package Body created with compilation errors.\n \n \nView created.\n \n \nPackage altered.\n \n \nView altered.\n \n \nGrant succeeded.\n \n \nTrigger created.\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nCall completed.\n \n \nSession altered.\n \n \nSession altered.\n \n \nFunction created.\n \n \nno rows selected\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nPackage created.\n \n \nno rows selected\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nPackage created.\n \n \nno rows selected\n \n \nPackage body created.\n \n \nno rows selected\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nPackage created.\n \n \nno rows selected\n \n \nPackage body created.\n \n \nno rows selected\n \n \nGrant succeeded.\n \n \nSynonym created.\n \n \nPackage created.\n \n \nno rows selected\n \n \nPackage body created.\n \n \nno rows selected\n \n \nSynonym created.\n \n \nGrant succeeded.\n \n \nspecify password for OE as parameter 1:\n \nPROMPT password for SYS as parameter 2:\n \nspecify connect string as parameter 3:\n \n \nPL\/SQL procedure successfully completed.\n \nConnected.\nDROP DIRECTORY SS_OE_XMLDIR\n*\nERROR at line 1:\nORA-04043: object SS_OE_XMLDIR does not exist\n \n \n \nDirectory created.\n \n \nCommit complete.\n \nConnected.\n \nRevoke succeeded.\n \nConnected.\nConnected.\n \nSession altered.\n \n \nPL\/SQL procedure successfully completed.\n \n \nPL\/SQL procedure successfully completed.\n \n \nPL\/SQL procedure successfully completed.\n \n \nCall completed.\n \n \nCall completed.\n \n \nPL\/SQL procedure successfully completed.\n \nConnected.\n \nRevoke succeeded.\n \nConnected.\nConnected.\n \nRevoke succeeded.\n \n \nRevoke succeeded.\n \n \nRevoke succeeded.\n \n \nPackage dropped.\n \n \nPackage dropped.\n \n \nPackage dropped.\n \n \nPackage dropped.\n \n \nPackage dropped.\n \n \nTrigger dropped.\n \n \nView dropped.\n \nConnected.\n \nCommit complete.\n \n \nspecify Sample Schema version as parameter 1:\n \nspecify location for data and control files as parameter 2:\n \nspecify location for log files as parameter 3:\n \nspecify password for oe as parameter 4:\n \nSetting FEEDBACK OFF for inserts\n \nSetting FEEDBACK ON\n \n \n1 row created.\n \n \n1 row created.\n \n \nCommit complete.\n \n \nTable altered.\n \n \nSession altered.\n \n \nSession altered.\n \n \nCommit complete.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nFunction created.\n \n \nView created.\n \n \nView 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 \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment created.\n \n \nComment 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 \nIndex created.\n \n \nIndex created.\n \n \nIndex created.\n \n \nSession altered.\n \n...creating subschema OC in OE\n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType created.\n \n \nType body created.\n \n \nType created.\n \n \nType body created.\n \n \nType created.\n \n \nType body created.\n \n \nTable created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nView created.\n \n \nTrigger created.\n \n \nTrigger created.\n \n \nCommit complete.\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 \nType altered.\n \n \n3 rows updated.\n \n \n8 rows updated.\n \n \n6 rows updated.\n \n \n4 rows updated.\n \n \nCommit complete.\n \n \nType body altered.\n \n \nType body altered.\n \n \nType body altered.\n \n \nPL\/SQL procedure successfully completed.\n \nConnected.\n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \n \nSynonym created.\n \nnot spooling currently\nSQL&gt;\n<\/pre><\/div>\n\n\n<p>Validando:<\/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 username,account_status from dba_users where username=&#039;OE&#039;;\n \nUSERNAME\n--------------------------------------------------------------------------------\nACCOUNT_STATUS\n--------------------------------\nOE\nOPEN\n \n \n1 row selected.\n \nSQL&gt; SELECT COUNT(*) FROM DBA_OBJECTS WHERE OWNER=&#039;OE&#039;;\n \n  COUNT(*)\n----------\n       142\n \n1 row selected.\n \nSQL&gt; CONN OE\/oracle\nConnected.\nSQL&gt; SHOW USER;\nUSER is &quot;OE&quot;\nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Precisava criar o schema OE para um laborat\u00f3rio espec\u00edfico, mas percebi que n\u00e3o o tinha em meu banco de dados, mas que tamb\u00e9m n\u00e3o possu\u00eda o seu script de cria\u00e7\u00e3o no bin\u00e1rio instalado (vers\u00e3o 19C): Lendo a documenta\u00e7\u00e3o da Oracle, percebi que a partir da release 12.2, apenas o script do schema HR est\u00e1 dispon\u00edvel [&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-3497","post","type-post","status-publish","format-standard","hentry","category-administration"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3497","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=3497"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3497\/revisions"}],"predecessor-version":[{"id":9189,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/3497\/revisions\/9189"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=3497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=3497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=3497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}