Rename the INSTANCE or the DATABASE?
The first requires you may new services on NT with the new
name, copy the existing cofig file to one with the new name and
...hmm actually that's about it. The other requires you make
a new control file with the create control file command
specifying the new name of the database in the command.
If this is not a large database and you actually want to do
both - export the current database, shutdown the existing one,
delete all files and services and use the assistant to make a
new database/instance with the proper name then import the
orginal from the export file.
> Hello,
>
> i have an Oracle Instance (Name: Test). Now i want rename the
instance Name
> to XXXX. What must i do??
> I work with Oracle 7.3.4.2 and the operating system is
Windows NT SP5.
>
> Thanks for your Help
>
> Regards.
>
> Axel
>
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=8613&cus_id=USENET&qtn_id=7384
Received on Mon Dec 13 1999 - 09:43:55 CST
