This is an old revision of the document!


Oracle Requirements

Stages supports the following Oracle versions:

  • 10g
  • 11g
  • 12c

For Oracle 12.2, this patch needs to be installed: Patch #25818707: PLSQL COMPILATION FAILS WITH ORA-06555 WHEN USING STANDARD OBJECT NAME IN 12.2 <font inherit/inherit;;#e74c3c;;inherit>(NEW FOR 7.2!)</font>

Stages requires a separate tablespace on the Oracle Server.

To access Oracle with Stages a technical/proxy user with at least the following permissions is necessary:

  • CREATE SESSION
  • CREATE SEQUENCE
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE PROCEDURE
  • CREATE VIEW
  • CREATE MATERIALIZED VIEW
  • EXECUTE ON SYS.DBMS_CRYPTO <font inherit/inherit;;#e74c3c;;inherit>(NEW FOR 7.2!)</font>
  • QUERY REWRITE
  • UNLIMITED TABLESPACE (or enough tablespace)

Stages needs <font 14px font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;/ ;;rgb(0, 0, 0) font-family: “Segoe UI”, “Helvetica Neue”, “Apple Color Emoji”, “Segoe UI Emoji”, Helvetica, Arial, sans-serif; font-size: 14px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;;;inherit>a database with NLS_LENGTH_SEMANTICS=CHAR</font>