Oracle: Unterschied zwischen den Versionen
Aus MeinWiki
(Die Seite wurde neu angelegt: „== Speicherplatz vergrößern == *um ein File ALTER TABLESPACE "Tablespace" ADD DATAFILE '/opt/oracle/oradata/"SID"/Tablespace.dbf' SIZE 100M…“) |
K |
||
| Zeile 1: | Zeile 1: | ||
| − | == | + | == Tablespace erweitern == |
*um ein File | *um ein File | ||
ALTER TABLESPACE "Tablespace" | ALTER TABLESPACE "Tablespace" | ||
ADD | ADD | ||
| − | DATAFILE '/opt/oracle/oradata/"SID"/Tablespace.dbf' SIZE 100M | + | DATAFILE '/opt/oracle/oradata/"SID"/"Tablespace".dbf' SIZE 100M |
AUTOEXTEND | AUTOEXTEND | ||
| − | ON NEXT 100M MAXSIZE 2048M, | + | ON NEXT 100M MAXSIZE 2048M; |
| + | |||
| + | *um mehrere Files | ||
| + | ALTER TABLESPACE "Tablespace" | ||
| + | ADD | ||
| + | DATAFILE '/opt/oracle/oradata/"SID"/"Tablespace".dbf' SIZE 100M | ||
| + | AUTOEXTEND | ||
| + | ON NEXT 100M MAXSIZE 2048M, '/opt/oracle/oradata/"SID"/"Tablespace"..dbf' SIZE 100M AUTOEXTEND | ||
| + | ON NEXT 100M MAXSIZE 2048M, '/opt/oracle/oradata/"SID"/"Tablespace"..dbf' SIZE 100M AUTOEXTEND | ||
| + | ON NEXT 100M MAXSIZE 2048M; | ||
Version vom 25. August 2014, 06:12 Uhr
Tablespace erweitern
- um ein File
ALTER TABLESPACE "Tablespace" ADD DATAFILE '/opt/oracle/oradata/"SID"/"Tablespace".dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
- um mehrere Files
ALTER TABLESPACE "Tablespace" ADD DATAFILE '/opt/oracle/oradata/"SID"/"Tablespace".dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M, '/opt/oracle/oradata/"SID"/"Tablespace"..dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M, '/opt/oracle/oradata/"SID"/"Tablespace"..dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE 2048M;
