SQL created by Oracle Tablespace

1. Create a table space
Create Tablespace SIRM2
DataFile ' D:\oracle\product\10.2.0\oradata\orcl\SIRM2.dbf '

Size 1024M--storage address Initial size 1G
Autoextend on next 10M--10M per expansion

--maxsize 2024M--

MaxSize Unlimited--Unlimited expansion

EXTENT MANAGEMENT Local Autoallocate
Segment Space management auto;

Add multiple files simultaneously: Alter tablespace venn add datafile '/opt/oracle/db01/app/oracle/oradata/ossorcl/venn02.dbf '

Size 10Mautoextend on next 100Mmaxsize 500M,'/opt/oracle/db01/app/oracle/oradata/ossorcl/venn02.dbf ' size 10Mautoextend on next 100Mmaxsize 500M;

Add data files
ALTER tablespace Game
ADD datafile '/oracle/oradata/db/game02.dbf ' SIZE 1000M;

SQL created by Oracle Tablespace