Create tablespace in Oracle
|
|
|
|
|
  OraDev.com
|
Create tablespace in Oracle
This article describes how to create a tablespace in Oracle
The basic command is:
CREATE TABLESPACE tablespacename>
datafile '/dir/datafilename.dbf'
size
for example:
CREATE TABLESPACE temp_tbs
datafile '/dir/temptbs.dbf'
size 64m;
extra options
With the create tablespace command you can add a lot of options. For example:
autoextend {on|off}
blocksize size
extend management local {AUTOALLOCATE | UNIFORM SIZE extent_size}
next 10m
maxsize 200m
online|offline
flashback {on|off}
segment space management {auto|manual}
|
|
|
|
|
|