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

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 03 Jun 2008 10:08:41 -0700
Message-ID: <1212512919.502129@bubbleator.drizzle.com>


emdproduction_at_hotmail.com wrote:
> 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

Why is the name of an ASM data file, or for that matter the name of a database relevant to its use? I'd have changed the entry in the tnsnames.ora and gone to something more interesting.

My advice: The file name is an irrelevancy ... ignore it.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jun 03 2008 - 12:08:41 CDT

Original text of this message