Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Change of a database name
The "create controlfile" command works just fine. The first time you use it does cause a bit of anxiety but just use good caution --- back up the current db 1st!
You can also use "create controlfile" to copy an existing db to another machine or the same machine (of course, all the files must be copied too). The other machine should be the same platform and OS version. Also, you would most likely need to edit the file names in the script created by "alter database backup controlfile to trace" to reflect the new locations.
Good luck
Chuck Coryea
![]() |
![]() |