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: Change of a database name

Re: Change of a database name

From: ctcoryea <ctcoryea_at_ix.netcom.com>
Date: 1998/02/17
Message-ID: <01bd3b47$64a9ac40$01c8c8c8@coryeasrv1>#1/1

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



remove xxxx in reply-to address Received on Tue Feb 17 1998 - 00:00:00 CST

Original text of this message

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