Home » RDBMS Server » Server Administration » Changing the database Name
Changing the database Name [message #57785] Mon, 07 July 2003 23:04 Go to next message
Joseph
Messages: 30
Registered: June 2002
Member
Dear Sir,

I have a database running with the name joe and there are around 200 users who are connected to it. Now i want to change the database name, how can i change the database name so that it will no effect the server much

Report message to a moderator

Re: Changing the database Name [message #57899 is a reply to message #57785] Wed, 16 July 2003 16:32 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
Joe,
You could consider just adding a new database service name into the tnsnames.ora file on the client computeres. Here is an example file:
http://www.dotcomsolutionsinc.net/products/installgen/sol_920_64bit_files/installgen_sol920_25_.html

For this example, you could take the top entry which is PROD1, copy the service name entry, and use this info to create a new service name which the new name you want to use. Then you could switch your users over to using the new service name gradually so that they suffer no downtime.

Report message to a moderator

Previous Topic: Storing Word docs in Oracle
Next Topic: export backup error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:27:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.