Try ls -ltr /*/oradata/db_name1/*
Didn't think of that, didja.
It's actually pretty cool that (in Unix) you can actually reference
all your data/log/control files with one filespec. Doesn't work
well on NT, but it's better than non-OFA.
HTH,
Yosi
"Hagedorn, Linda" wrote:
Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point?
e.g..
/u02/oradata/db_name1/userdata01.dbf
/u02/oradata/db_name2/userdata01.dbf
/u03/oradata/db_name1/userdata02.dbf
/u03/oradata/db_name2/userdata02.dbfYou cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way.
Any input, pro or con, is appreciated.
Thanks, Linda
--
Thanks,
Yosi
---------------------------------------------------------
Yosi Greenfield
Oracle Certified DBA
[EMAIL PROTECTED]