如何查看oracle表空间数据文件位置

Question

如题所述

Answer 1

select tablespace_name, file_id, file_name,round(bytes/(1024*1024),0) total_spacefrom dba_data_filesorder by tablespace_name