what is the best way to change a file name within the same asm disk group?

From: <emdproduction_at_hotmail.com>
Date: Mon, 2 Jun 2008 19:39:49 -0700 (PDT)
Message-ID: <838b8cee-b8e4-44d8-aff6-601c4b86a780@w7g2000hsa.googlegroups.com>


Dear group,

I am using Oracle 10.2.03 on linux.

I used nid to change the dbname from "test" to "dev", but select name from v$datafile still show
filename as "+data1/test/users.xxxx", so I have to use RMAN "copy datafile 'xxx' to '+data1' to change the file path, it is very slow.

It there any better way to do this?

Thanks for your help Received on Mon Jun 02 2008 - 21:39:49 CDT

Original text of this message