| Auszug |
|---|
|
Create an Oracle schema for Nuclos manually: create tablespace and set up user and schema with the required grants. |
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.
| Status |
|---|
| colour | Blue |
|---|
| title | Operations |
|---|
|
| Status |
|---|
| colour | Green |
|---|
| title | Updated: Jul 2026 |
|---|
|
| Status |
|---|
| colour | Grey |
|---|
| title | applies to Nuclos 4.2026.x |
|---|
|
| Info |
|---|
|
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
| Codeblock |
|---|
|
CREATE TABLESPACE DAT_<tablespacename> DATAFILE '<oracle-tablespace-verzeichnis>/dat_<tablespacename>.ora' SIZE 100M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED; |
b) Create user and schema
| Codeblock |
|---|
|
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
Oracle database (DE)
Oracle basics & nuclos.xml.
Open →
