globe with meridians Language: Deutsch · English

hammer and wrench Oracle: create schema

Manually create tablespace, user and schema for Nuclos in Oracle – if you don't use the @create.sql script.

HOW-TO OPERATIONS UPDATED: JUL 2026 APPLIES TO NUCLOS 4.2026.X

On this page

Prefer the script

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

a) Create tablespace

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

b) Create user and schema

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;

Related pages

file cabinet Oracle database (DE)

Oracle basics & nuclos.xml.

Open →

  • Keine Stichwörter