RE: rename a database

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Mon, 19 May 2008 15:16:20 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A07C58726@VEXBE2.ex.ad3.ucdavis.edu>


Metalink has a document giving step by step procedures for doing this. Sorry, I don't have the docid at my fingertips.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Finn Jorgensen Sent: Monday, May 19, 2008 12:11 PM
To: genegurevich_at_discover.com
Cc: oracle-l
Subject: Re: rename a database

Yep, that's still how it's done.

I just did one today :)

Finn

On 5/19/08, genegurevich_at_discover.com <genegurevich_at_discover.com> wrote:
> Hello :
>
>
> I need to rename an existing database (10.2.3). In the past (about 10
years
> ago and oracle 7) I was able to take the create controlfile command
> (via alter database rebuild controlfile to trace), replace the
filesystem
> name and the database name with a new instance name, rename
> all the filesystems accordingly, execute the create controlfile
command and
> be done.
>
> As I said I have not done it in about 10 years. Can this still be done
like
> that? Am I missing anything?
>
> thank you
>
> Gene Gurevich
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 19 2008 - 17:16:20 CDT

Original text of this message