Sign our RSS

Creating a tablespace on Oracle

Guys last days i need to create a new tablespace in oracle. The command syntax is very simple,  you just need to choose a table space name and size and run the follow command.

Remembering thats the basic way with few parameters, if you search on google you will find different ways buts this one can give you a start.

create tablespace BIG_ARCH
logging
datafile ‘C:\oracle\product\10.2.0\oradata\your_db_name\big_arch.DBF’
size 12000m
autoextend on
next 32m maxsize 12000m
extent management local;