Language: Deutsch · English
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 STAND: JUL 2026 GILT FUER NUCLOS 4.2026.X
Auf dieser Seite
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
Überblick
Inhalte