www.oradev.com
  Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages
Create tablespace in Oracle

Database/Sql

Pl/sql tools
create table
Database scheduler
create tablespace
dba metrics
Table with sequenced numbers
Autonomous transaction
ORA-12537 error
Parse a String in pl/sql
Export with oracle datapump


  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}