Home » SQL & PL/SQL » SQL & PL/SQL » Swapping Synonyms in production (10G Oracle Spatial)
Swapping Synonyms in production [message #359655] Mon, 17 November 2008 20:41 Go to next message
TJPokala
Messages: 17
Registered: March 2008
Junior Member
Is it a good idea to swap synonyms in production environment.For Example:

table A is PROD
table B is staging table

Once new data comes in we update table B with new data and swap teh synonyms so table B will be the new PROD table.

Has anyone had experience swapping synonyms automatically in PROD environment?
Re: Swapping Synonyms in production [message #359656 is a reply to message #359655] Mon, 17 November 2008 21:16 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

It is not Automatic. Use Create Or Replace clause for creating Synonym

Smile
Rajuvan.
Re: Swapping Synonyms in production [message #359673 is a reply to message #359656] Tue, 18 November 2008 00:00 Go to previous messageGo to next message
TJPokala
Messages: 17
Registered: March 2008
Junior Member
Hi Raja..I knwo its not automatic...What I am doing is swapping teh synonyms between table A and B for publishing and staging purpose.

But currently we ar emoving to PROD , and Is performing DDL a wise Idea..If not how to go abt this..I can't use alter materialized view because spatial data cannot be refreshed.
Re: Swapping Synonyms in production [message #359778 is a reply to message #359673] Tue, 18 November 2008 03:32 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Switching the synonym will certainly be quicker than moving the table.
You will need to ensre that all the constraints (FK and other), triggers and indexes that are present on PROD get created on your staging table.
Re: Swapping Synonyms in production [message #359790 is a reply to message #359778] Tue, 18 November 2008 04:02 Go to previous message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And privileges.

Regards
Michel
Previous Topic: Case Expression
Next Topic: Find a break in number sequence
Goto Forum:
  


Current Time: Fri Dec 09 11:45:55 CST 2016

Total time taken to generate the page: 0.19520 seconds