Re: How to change SID

This can be done fairly easily (I've done it, but need to find the scripts I created).

What you end up doing is creating a new initxxx.ora file (obviously) and changing the control files. There is a command that creates an ASCII version of the control files. I do remember that Oracle was not very happy about us doing this, so it may not be a good thing to do for a production database.

-- 

+---------------------------------------+-------------------------------+
| David Kaiser                          | e-mail: davidk_at_sfmic.com      |
| Project Manager                       |    WWW: http://www.sfmic.com  |
| State Fund Mutual Insurance Company   |                               |
| 7500 Flying Cloud Drive, Suite 900    |  voice: 612.914.1317          |
| Eden Prairie, MN 55344  USA           |    fax: 612.944.1169          |
+---------------------------------------+-------------------------------+


MCR <mrush_at_hertz.com> wrote in article
<01bc7b54$2b8a8960$163f04d8_at_mrush.hertz.com>...


> What are the steps involved in changing the SID of a database?

> 

> I think I saw this in a DBA type magazine a few months ago.  Anyone

> remember which one?

> 

> Thanks

> 

> M. C. Rush

> mrush_at_hertz.com

>