Friday, 14 March 2014

Script to find duplicate datafiles in Oracle

Query to Check duplicate datafiles in Oracle

select substr ( file_name, instr( file_name, '/', -1)) file_name, count(*)
from dba_data_files
group by substr ( file_name,instr( file_name, '/', -1))
having count(*) > 1
/

No comments:

Post a Comment