This is an old revision of the document!

Oracle Requirements

Stages supports the following Oracle versions:

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

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
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”.