• Creating a tablespace on Oracle

    Posted on January 21st, 2010 admin No comments

    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
    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;