Query to generate SET NEWNAME for DATAFILE
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