How to check repeated datafiles Posted by Roger Jerdez on September 28, 2015 Get link Facebook X Pinterest Email Other Apps 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
Comments