SELECT ‘CREATE TABLESPACE ‘		TABLESPACE_NAME		’ DATAFILE ‘		CHR(39)		file_name
CHR(39)		’ SIZE ‘		ROUND(SUM(BYTES)/1024/1024*1.2)		‘M REUSE ;’ FROM DBA_DATA_FILES WHERE TABLESPACE_NAME NOT IN (‘SYSTEM’,’USERS’,’INDX’,’CWMLITE’,’TOOLS’,’EXAMPLE’,’ODM’,’XDB’,’TEMP’) AND TABLESPACE_NAME NOT IN ( SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE CONTENTS=’TEMPORARY’) GROUP BY TABLESPACE_NAME, FILE_NAME ;