Create an Oracle schema for Nuclos manually: create tablespace and set up user and schema with the required grants.

On this page

If available, prefer the @create.sql script – it reliably grants all required privileges. Use the steps below only when working without the script.

CREATE TABLESPACE DAT_<tablespacename> DATAFILE '<oracle-tablespace-verzeichnis>/dat_<tablespacename>.ora' SIZE 100M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;

CREATE USER <schemaname> IDENTIFIED BY <passwort> DEFAULT TABLESPACE DAT_<tablespacename> TEMPORARY TABLESPACE TEMP;
GRANT CONNECT TO <schemaname>;
GRANT DBA TO <schemaname>;
GRANT CREATE ANY SEQUENCE TO <schemaname>;
GRANT CREATE ANY VIEW TO <schemaname>;
ALTER USER <schemaname> DEFAULT ROLE ALL;