Thread started: Jun 29 2009, 5:52 AM EDT
Watch
set lines 130
set pages 2000
col file_name for a50
break on tablespace_name
select tablespace_name, file_name
from dba_data_files ddf ,
(
select substr(file_name,16) sstr
from dba_data_files
group by substr(file_name,16)
having count(substr( file_name ,16))> 1
) dup
where instr(ddf.file_name, dup.sstr) > 0;
out of
found this valuable.
Do you find this valuable?