Hi,

I am running Oracle 11.2.0.3 on Redhat Linux
I want to run a query to generate a command to rename ASM files:

This is how the ASM data looks:

+DATA/db1/datafile/report.180.248540158

This is how I want it to look:

SET NEWNAME FOR DATAFILE 1 TO ‘/u02/data/dev/db1/report.180.dbf’;

How can I write the query, using SUBSTR and INSTR to generate the command:
e.g. - SELECT ‘SET NEWNAME FOR DATAFILE ‘||FILE#||’ TO ‘’’||’/u02/……

To look like:

SET NEWNAME FOR DATAFILE 1 TO ‘/u02/data/dev/db1/report.180.dbf’;

Thanks,

Lucky