Create and drop a new tablespace in Oracle DB

Create New tablespace DATA

Create tablespace DATA datafile '/u01/app/oradata/data01.dbf' size 5G autoextend on next 500M;

Create tablespace on ASM diskgroup

Create tablespace DATA datafile '+DATAG' size 5G autoextend on next 500M;

Create big tablespace

CREATE BIGFILE TABLESPACE BIGTS datafile '/u01/app/oradata/bigts01.dbf' size 100G autoextend on NEXT 1G;

Drop tablespace in oracle DB

Drop a tablespace without removing the physical database files.

drop tablespace DATA;

Drop tablespace including the physical datafiles.

drop tablespace DATA including contents and datafiles;