Re: Rename an Oracle 91 database

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Tue, 04 Feb 2003 18:59:21 +0100
Message-ID: <nqvv3v05nkmjgf73dnuebrdvu048dj8hnc@4ax.com>

On Tue, 4 Feb 2003 13:13:49 -0000, "James Culleton" <jculleton_at_eircom.net> wrote:

>Hi,
>
>I've installed Oracle 9i server (release 2) 9.2.0.1.0 on a Windows 2000
>server. I created a database called "test" but now I would like to rename
>the database to something else. Is this possible? or would I have to create
>a new database and move the data across to it.
>
>Any help would be great
>
>James
>

It is possible to rename it. Check out the alter database command in your sql reference manual.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Feb 04 2003 - 11:59:21 CST