Differences

This shows you the differences between two versions of the page.

--- oracle:sqlplus_befehle [2020/02/10 16:13] – created stone
+++ oracle:sqlplus_befehle [2021/07/30 07:49] (current) – [5.) Datafile zu einem Tablespace hinzufügen] stone
@@ Line 266: / Line 266: @@
 ==== 5.) Datafile zu einem Tablespace hinzufügen ====
 <code>
-alter tablespace <tablespace> add datafile '</oracle/SID/oradata/name01.dbf>' size 1G autoextend on maxsize 32767M;
+alter tablespace <tablespace> add datafile '</oracle/SID/oradata/name01.dbf>' size 1G autoextend on next 1G maxsize 32767M;
 </code>