Oracle Requirements

Stages supports the following Oracle versions:

• 19c

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 set to “CHAR”.

It is recommended to set NLS_CHARACTERSET to “AL32UTF8” and NLS_NCHAR_CHARACTERSET to “AL16UTF16”.

For optimal performance, set the “cursor_sharing” parameter to “force”.