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