Basic SQL commands: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 10: | Line 10: | ||
== Add datafile to tablespace == | == Add datafile to tablespace == | ||
alter tablespace tablespacename | alter tablespace '''''tablespacename''''' | ||
add datafile '/path/to/ | add datafile ''''/''path''/''to''/''file''/''filename''.dbf'''' | ||
size 10m autoextend on | |||
next 5m maxsize 1G; | |||
Revision as of 02:54, 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/file/filename.dbf' size 10m autoextend on next 5m maxsize 1G;