Creating_Tablespace

•   CREATING LOCALLY MANAGED TABLESPACE WITH AUTOMATIC SEGMENT   SPACE MANAGEMENT

SQL> create tablespace tbs100 datafile '/u01/app/oracle/oradata/orcl/tbs100.dbf' size 50M segment space management auto;

• CREATING TABLESPACE WHERE EXTENT ALLOCATION IS AUTOMATIC

SQL> create tablespace tbs200 datafile '/u01/app/oracle/oradata/orcl/tbs200.dbf' size 50M extent management local autoallocate segment space management auto;

• CREATING TABLESPACE WHERE EXTENT ALLOCATION IS UNIFORM

SQL> create tablespace tbs300 datafile '/u01/app/oracle/oradata/orcl/tbs300.dbf' size 50M extent management local uniform size 64K segment space management auto;

• CREATE TABLES IN TABLESPACE TBS100

 
SQL> create table first (id number) tablespace tbs100;

• ENABLING AUTOEXTEND

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/tbs100.dbf' autoextend on;

• ENLARGING DATAFILE SIZE   

SQL> alter database datafile '/u01/app/oracle/oradata/orcl/tbs100.dbf' resize 100M;