It isn't possible. Because db_name and SID are stored in the controlfile. If
you are using Unix for your databases, you can check it with the strings
command. F.e.
[ccpr1:oracle]>strings /cc_prod/i00/oradbf/vanprod/control_file/cntrl03.ctl
| more
Z[\]
vanprod:/u00/app/oracle/release/v7.3.4
VANPROD
VANPROD
Pvanprod
Pvanprod
/cc_prod/s00/oradbf/vanprod/redologs/redo01.log
/cc_prod/s00/oradbf/vanprod/redologs/redo02.log
/cc_prod/s00/oradbf/vanprod/redologs/redo03.log
/cc_prod/s00/oradbf/vanprod/redologs/redo01.log
/cc_prod/s00/oradbf/vanprod/redologs/redo02.log
/cc_prod/s00/oradbf/vanprod/redologs/redo03.log
/cc_prod/s00/oradbf/vanprod/redologs/redo07.log
/cc_prod/s00/oradbf/vanprod/redologs/redo06.log
/cc_prod/s00/oradbf/vanprod/redologs/redo05.log
/cc_prod/s00/oradbf/vanprod/redologs/redo04.log
/cc_prod/s00/oradbf/vanprod/redologs/redo07.log
/cc_prod/s00/oradbf/vanprod/redologs/redo06.log
/cc_prod/s00/oradbf/vanprod/redologs/redo05.log
/cc_prod/s00/oradbf/vanprod/redologs/redo04.log
/cc_prod/s00/oradbf/vanprod/redologs/redo08.log
..................................
..................................
> -----Mensaje original-----
> De: Koivu, Lisa [SMTP:[EMAIL PROTECTED]]
> Enviado el: martes 6 de marzo de 2001 21:40
> Para: Multiple recipients of list ORACLE-L
> Asunto: rename database
>
> Hello everyone -
>
> Is it possible to rename a database without recreating the controlfile? I
> have a feeling it isn't, but can someone verify?
>
> Thanks
>
> Lisa Rutland Koivu
> Oracle Database Administrator
> Qode.com
> 4850 North State Road 7
> Suite G104
> Fort Lauderdale, FL 33319
>
> V: 954.484.3191, x174
> F: 954.484.2933
> C: 954.658.5849
> <http://www.qode.com>
>
> "The information contained herein does not express the opinion or position
> of Qode.com and cannot be attributed to or made binding upon Qode.com."
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Trassens, Christian
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
