Modification TBS

SELECT tablespace, file_name FROM dba_temp_files;
SELECT tablespace, file_name FROM dba_data_files;

create tablespace STATSPACK datafile '<file>' size 250M reuse extent management local uniform size 1M;

# Temporary
create temporary tablespace STATSTEMP tempfile '<file>' size 50M reuse extent management local uniform size 1M;

ALTER TABLESPACE <tbs> ADD DATAFILE  '<file>'SIZE 25M AUTOEXTEND OFF;
ALTER TABLESPACE <tbs> DROP DATAFILE '<file>' ;

ALTER DATABASE DATAFILE '<file>' RESIZE 225M;
ALTER DATABASE TEMPFILE '<file>' RESIZE 2048M;

DROP tablespace <tbs> INCLUDING CONTENTS and datafiles;