Basic SQL commands: Difference between revisions
From Peter Pap's Technowiki
Jump to navigation
Jump to search
|
|
| Line 1: |
Line 1: |
| == 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;
| |
Latest revision as of 02:55, 11 January 2012