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
