Difference between revisions of "Basic SQL commands"
From Peter Pap's Technowiki
(→Add datafile to tablespace) |
|||
| Line 9: | Line 9: | ||
== Add datafile to tablespace == | == Add datafile to tablespace == | ||
| + | |||
| + | alter tablespace tablespacename | ||
| + | add datafile '/path/to/datafile/datafile | ||
Revision as of 02:53, 11 January 2012
Create tablespace
create tablespace tablespacename datafile '/path/to/file/filename.dbf' size 10m autoextend on next 5m maxsize 1G;
This will create a 20mb datafile that will extend by 5mb until it gets to 1gb max.
Add datafile to tablespace
alter tablespace tablespacename add datafile '/path/to/datafile/datafile
