Home » RDBMS Server » Server Administration » Merge database& issues (General question)
Merge database& issues [message #334409] Wed, 16 July 2008 07:03 Go to next message
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member

Have you guys ever come across merging two databases ?There was a decision in our env to merge a reporting database to development/UAT databases (might be for testing purpse) .But public synonyms are the main conflict .
Do you think changing public synonym name is the only option ?any experience ?
Re: Merge database& issues [message #334415 is a reply to message #334409] Wed, 16 July 2008 07:26 Go to previous message
Messages: 3202
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Depends what they are used for.

If they logically belong to the application, then they shouldn't be *public* synonyms in the first place, but only be present in the application schema.
Previous Topic: auto export while windows is starting
Next Topic: TNSping ok..can't connect with sqlPlus ...just stopped working
Goto Forum:

Current Time: Tue Aug 22 08:14:57 CDT 2017

Total time taken to generate the page: 0.04281 seconds