FIND USER ANY PERTICULAR TABLESPACE and DATAFILES

USER PERTICULAR TABLESPACE and DATAFILES

SELECT * FROM DBA_DATA_FILES d WHERE d.tablespace_name in (select distinct tablespace_name from dba_segments Where OWNER = upper(‘&username’)) order by 1;