SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

finding duplicate file names

Ora_83Mar 17 2011 — edited Mar 17 2011

Hello

How can I find the duplicate file names in database?

select substr( file_name , instr (file_name, '/',-1)+1) from dba_data_files;

users.dbf01
tools.dbf01
tools.dbf02
..
..

What I want to find is, I want to find the duplicate file names.

ie:

users.dbf01
users.dbf01
sysaux.dbf02
sysaux.dbf02
..
..

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 14 2011

Added on Mar 17 2011

4 comments

977 views