Conocer las Tablespace
select * from user_tablespaces;

Crear un TableSpace
create tablespace Info datafile
'c:/info.dbf' size 10m
autoextend on next 10m maxsize unlimited;

Agregar mas espacio al TableSpace
 alter tablespace Info add datafile 'C:/info2.dbf' size 10m
 autoextend on next 10m maxsize unlimited;    

Eliminar un TableSpace
drop tablespace Info including
contents and datafiles;