Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I change db_name or SID for a exist db or How?

Re: Can I change db_name or SID for a exist db or How?

From: koert54 <koert54_at_nospam.com>
Date: Sat, 13 Jul 2002 16:20:03 GMT
Message-ID: <TqYX8.3185$8o4.479@afrodite.telenet-ops.be>


don't forget 'alter database rename global_name to <newname>;' !

"owalter" <member_at_dbforums.com> wrote in message news:3d2fd3a0$1_at_usenetgateway.com...
> Quite late but perhaps it may help anybodyx else :)
>
> After u have done : ALTER DATABASE BACKUP CONTROLFILE TO TRACE edit the
> file (normally under udump/)
>
> in following way:
>
> CREATE CONTROLFILE REUSE DATABASE "OLD_NAME" NORESETLOGS NOARCHIVELOG
>
> to
>
> CREATE CONTROLFILE SET DATABASE "NEW_NAME" RESETLOGS NOARCHIVELOGsa
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
Received on Sat Jul 13 2002 - 11:20:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US