Basic SQL commands: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
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 | ||
next 5m maxsize 1G; | next 5m maxsize 1G; | ||
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;