Thanks a lot, Jared and everyone else, much appreciated. Some good ideas and avenues there for me to explore further. -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx Jared Still wrote,on my timestamp of 14/08/2008 9:39 AM:
I use the db_file_name_convert log_file_name_convert parametersin the init.ora. My method is to query v$datafile and v$logfile, along withother file v$ views, to generate the initi.ora parameters, generate mkdir commands and whatever else is needed when the destination of the new files does not match the source. mkdir probably isn't needed, RMAN will likely do that, but it's just an old habit at this point. snip...
-- //www.freelists.org/webpage/oracle-l