| duplicate datafile name [message #545437] |
Wed, 29 February 2012 08:16  |
caprikar
Messages: 226
Registered: March 2007
|
Senior Member |
|
|
Hi,
I have oracle 10g running on Solaris with file system and some one created database files with same name but in different directories for example data01.dbf in two different directories, say /u01/oradata/data01.dbf and /u02/oradata/data01.dbf. Now, I want to find out the duplicate datafiles (data01.dbf in this case) sitting in different directories, is there anyway to find this out?
Thanks.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: duplicate datafile name [message #545442 is a reply to message #545439] |
Wed, 29 February 2012 08:43  |
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
|
Well unless you've got a ridiculously large number of datafiles you should be able to spot the duplicates by eye, but if you want to use sql then just use a combo of instr and substr to get the characters in the file_name column that come after the final /
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: duplicate datafile name [message #545693 is a reply to message #545462] |
Thu, 01 March 2012 13:09 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
caprikar wrote on Wed, 29 February 2012 07:51The reason is, I have to backup this database and restore it in a different server under only one file system.
Thanks
> /u01/oradata/data01.dbf and /u02/oradata/data01.dbf
NOTHING prevents you from supporting the two paths above on a single filesystem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
