Re: Rename database

Koert,

    Is doing only:

        > - alter database rename global_name to <<new name>>

   not enough for the problem ?

Thanks,

Steven Brangers.

"koert54" <koert54_at_nospam.com> schreef in bericht news:Kb1v7.85376$6x5.19000573_at_afrodite.telenet-ops.be...
> Hi Franky !
>
> yes it is possible to change the DB name.
> The maximum length is 4 characters in Oracle 7, 8.0 and 8 characters in
> Oracle 8i (if I'm not mistaking)
>
> Here's (in short) the procedure
> - alter database backup controlfile to trace ;
> - check udump for the trace file - rename to something like control.sql
> - edit control.sql
> -> remove all comments & crap - also remove the 'recover database' and
> 'alter database open' statement at the end
> -> change 'reuse' to 'set'
> -> change the dbname to something else
> -> change 'noresetlogs' to 'resetlogs'
> - shutdown the database (warning - don't do a shutdown abort because
you're
> going to do a resetlogs afterwards!)
> - make a backup if you're faint of heart
> - delete the controlfiles (better - move them !)
> - sqlplus internal (or svrmgrl \ connect internal)
> - start control.sql
> - alter database open resetlogs
> - alter database rename global_name to <<new name>>
>
> Cheers !
> koert
>
> "Franky Thiel" <franky.thiel_at_infohos.be> wrote in message
> news:3bbc4cd5$0$36471$ba620e4c_at_news.skynet.be...
> > Is it possible to rename a database or should I do an export from the
old
> > database, drop database and recreate new database and do an import ?
> >
> > What is the maximum length of the name of a database in Oracle ?
> >
> >
> >
> > Regards and thanks in advance,
> >
> >
> >
> > Franky
> >
> >
> >
>
>
Received on Fri Oct 12 2001 - 20:16:35 CDT