Oracle查看表空间、删除表空间

select tablespace_name,file_id,bytes/1024/1024,file_name
　　 from dba_data_files order by file_id;

删除表空间
alter tablespace "GSQGOV" offline;
drop tablespace "GSQGOV" including contents and datafiles;

直接执行语句：drop tablespace 表空间名字 including contents and datafiles;