02-Tablespace.txt

select tablespace_name from dba_tablespaces;

create tablespace human
datafile 'human.dbf'
size 10M autoextend on;

create temporary tablespace human_tmp
tempfile 'human_tmp.dbf'
size 5M reuse autoextend on;

drop tablespace human 
including contents and datafiles;

drop tablespace human_tmp 
including contents and datafiles;