Create tablespace in Oracle

You can create a tablespace by using create tablespace command:

Syntax:

Create tablespace tablespace_name

        datafile 'file_name' size 10m

autoextent on next 5m maxsize 200m; 

We recommend that you include the following in the datafile name when you create the tablespace:

1. The name of the database
2. The name of the tablespace
3. A number that makes the datafile unique

create tablespace tbs

     datafile '/opt/luck/tbs01.dbf ' size 100m

autoextend on next 5m maxsize 200m;

People who read this post also read :

Posted in: Tablespace