Home » RDBMS Server » Server Administration » How to change the global names of a database
How to change the global names of a database [message #50643] Thu, 28 March 2002 05:44 Go to next message
Sunny
Messages: 25
Registered: November 2001
Junior Member
How to change the global names of a database without creating the database again.

Report message to a moderator

Re: How to change the global names of a database [message #50647 is a reply to message #50643] Thu, 28 March 2002 08:00 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
To change the global name, use the following command:

SQL> ALTER DATABASE RENAME GLOBAL_NAME TO NEW_NAME;

Always have a good backup before you alter the database.

Report message to a moderator

Previous Topic: Re: MOVE DATA FROM ONE DB TO ANOTHER
Next Topic: How to check for corruption on LOB datafile?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 16:06:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.