Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Rename an Oracle Instance

Re: Rename an Oracle Instance

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Thu, 12 Jul 2001 11:04:06 -0700
Message-ID: <3B4DE696.2EB3170C@attws.com>

Brian Peasland wrote:

> Stelios,
>
> Yes, you can rename your database on NT. Use the ORADIM80 utility to
> delete your old services and create new ones. Just type 'ORADIM80' on
> the command line for help information.
>
> HTH,
> Brian
>
> Stelios Karkazis wrote:
> >
> > Hi all,
> >
> > I have an NT 4.0 server with an Oracle Database (8.05) installation,
> >
> > I wonder if I can rename my instance to DEV, I mean if there is a way to
> > change also the Services in NT without create a new database and copy the
> > whole thing in it, 'cause I have not enough space.
> >
> > Thanks in advance
> >
> > Stelios Karkazis

Or just go into TNSNAMES.ORA, change the alias to DEV, and save the file. The instance's name is irrelevant.

Daniel A. Morgan Received on Thu Jul 12 2001 - 13:04:06 CDT

Original text of this message

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