create tablespace

create temporary tablespace temp_space_d08
tempfile 'temp_space_d08.dbf'
size 10m
autoextend on
next 5m
maxsize 1024m;

create tablespace space_d08
datafile 'space_d08.dbf'   --datefile
size 10m
autoextend on
next 5m
maxsize 1024m;

create user user_d08 identified by user_d08
default tablespace space_d08
temporary tablespace temp_space_d08;

grant connect,resource to user_d08;

drop user user_d08 cascade;

drop tablespace space_d08 including contents and datafiles cascade constraints;
drop tablespace temp_space_d08 including contents and datafiles cascade constraints;