Re: rename a database

It should work old fashion way
or you can use DBNEWID

HTH
Mayen

genegurevich_at_discover.com
Sent by: oracle-l-bounce_at_freelists.org
May 19 2008 02:57 PM
Please respond to
genegurevich_at_discover.com

To
"oracle-l" <oracle-l_at_freelists.org>
cc

Subject
rename a database

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 Received on Mon May 19 2008 - 14:08:56 CDT