Difference between revisions of "Basic SQL commands"
From Peter Pap's Technowiki
(Created page with " == Create tablespace == create tablespace gkdata datafile '/path/to/file/filename.dbf' size 10m autoextend on next 5m maxsize 1G;") |
(→Create tablespace) |
||
| Line 2: | Line 2: | ||
== Create tablespace == | == Create tablespace == | ||
| − | create tablespace | + | create tablespace ''tablespacename'' |
| − | datafile '/path/to/file/filename.dbf' | + | datafile '''/path/to/file/filename.dbf''' |
size 10m autoextend on | size 10m autoextend on | ||
next 5m maxsize 1G; | next 5m maxsize 1G; | ||
| + | |||
| + | |||
| + | == Add datafile to tablespace == | ||
Revision as of 02:50, 11 January 2012
Create tablespace
create tablespace tablespacename datafile /path/to/file/filename.dbf size 10m autoextend on next 5m maxsize 1G;
