smit_sign |

Duplicate datafile

samrat.wani

samrat.wani
Duplicate datafile
Jun 29 2009, 5:52 AM EDT | Post edited: Jun 29 2009, 5:52 AM EDT

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;
Do you find this valuable?    
Sign in to be the first to reply.