How to check repeated datafiles



How to check repeated datafiles 

set linesize 300
select tablespace_name,file_name from dba_data_files a
where 1< (select count(*)
from
dba_data_files b
where substr(a.file_name,24,60)=substr (b.file_name,24,60));

Comments