RE: rename database

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:lkoivu_at_qode.com]
> 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: CTrassens_at_uni2.es

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: ListGuru_at_fatcity.com (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).