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>
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