Difference between revisions of "Basic SQL commands"
From Peter Pap's Technowiki
|
|
| (One intermediate revision by the same user not shown) |
| 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/datafile/datafile
| |
Latest revision as of 02:55, 11 January 2012
