oracle查看某用户下表空间及存储路径

SELECT v1.*,v2.file_name from (
select tablespace_name,COUNT(1) countnum from dba_tables where owner=‘ZTSINFO_YJ_DEV’ and tablespace_name is not null
GROUP BY tablespace_name) v1 LEFT JOIN
(select * from dba_data_files) v2
on v1.tablespace_name = v2.tablespace_name;

ZTSINFO_YJ_DEV 代表用户名