Stages Documentation

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 (NEW FOR 7.2!)

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 (NEW FOR 7.2!)
  • QUERY REWRITE
  • UNLIMITED TABLESPACE (or enough tablespace)

Stages needs a database with NLS_LENGTH_SEMANTICS=CHAR. For optimal performance, set the “cursor_sharing” parameter to “force”.