Create, modify, and delete Oracle tablespaces

CREATE TABLE Space
Create tablespace myfirstspace datafile '/opt/oracle/app/oracle/product/9.2.0/dbs/myfirstspace.ora ' size 512M Autoextend on NEXT 5M MAXSIZE UNLIMITED default storage (initial 128K NEXT 2M pctincrease 0);
　　
Sql>create tablespace Fred
DataFile ' d:\oracle\oradata\orcl\fred01.dbf '
Size 100K reuse; (reuse for handling already existing datafiles)
　　
　　
To delete a table Space command:
Sql>drop tablespace INDX including contents;
Drop tablespace BLOBS including contents;
Drop tablespace BLOBS include contents and datafiles; (delete content and datafiles)
　　
To change the table space size command:
sql> ALTER database datafile ' indx.dbf ' resize 500M;

　
ALTER tablespace spacename ADD datafile ' c:\orant\database\usr02.dbf '
DEFAULT STORAGE (INITIAL 4M NEXT 2 M);

Create, modify, and delete Oracle tablespaces