This content has been marked as final. Show 3 replies
check in dba_temp_files also.
If they are not present in dba_data_files and dba_temp_files you can safely drop them i guess
i am planing to rename that, and let me check further. is there any option in asm to rename.
Please let me know.
Hi, for rename your files, the sintaxe is : select 'ALTER DATABASE RENAME FILE '''||NAME||''' TO '''||REPLACE(NAME,'+ORA_DATA','+NEW_DATA')||'''; ' FROM v$datafile;
Read the article <http://oraganism.wordpress.com/2012/07/01/how-to-rename-asm-diskgroup-in-11-2/> .