Re: Changing a database name

From: <shashism_at_my-dejanews.com>
Date: Tue, 30 Jun 1998 06:44:05 GMT
Message-ID: <6na1fl$p5a$1@nnrp1.dejanews.com>

Hi,

To change the name of the database follow the steps below.

1). Shutdown the database.
2). Using an Editor open the init.ora file ( e.g initorcl.ora file in the

                          $ORACLE_HOME\DATABASE\ directory )

3). Change db_name paramter to the name of the database you want give. 4). Startup the database using ORCALE_SID set to the name of the database.

Shashidhar S M

In article <6n8e2q$ref$1_at_camel19.mindspring.com>,   "walkerjo" <walkerjo_at_mindspring.com> wrote:
>
> I'm running Oracle version 8.0.4.0.0 on Windows NT 4.0. We have two
> databases (on different servers) with the same name. I would like to change
> the name of one to avoid any confusion that may come up. I've tried doing a
> full export and then inporting to a database with a different name. This
> didnt seem to work correctly since the data from my test database was not
> imported and the internal account was corrupted. Any suggestions on a
> easier more straight-forward way of doing this?
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Jun 30 1998 - 01:44:05 CDT