Re: Changing a database name

From: <rlkeller_at_my-dejanews.com>
Date: Thu, 02 Jul 1998 16:34:07 GMT
Message-ID: <6ngcpv$1ge$1@nnrp1.dejanews.com>

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?
>
>

Take a look at
ALTER database rename global_name to <new name>;

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 02 1998 - 11:34:07 CDT