OraFAQ Forum: SQL & PL/SQL » Swapping Synonyms in production

Home » SQL & PL/SQL » SQL & PL/SQL » Swapping Synonyms in production (10G Oracle Spatial)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Swapping Synonyms in production [message #359655]

Mon, 17 November 2008 20:41

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?

Report message to a moderator

Re: Swapping Synonyms in production [message #359656 is a reply to message #359655]

Mon, 17 November 2008 21:16

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.

Report message to a moderator

Re: Swapping Synonyms in production [message #359673 is a reply to message #359656]

Tue, 18 November 2008 00:00

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.

Report message to a moderator

Re: Swapping Synonyms in production [message #359778 is a reply to message #359673]

Tue, 18 November 2008 03:32

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.

Report message to a moderator

Re: Swapping Synonyms in production [message #359790 is a reply to message #359778]

Tue, 18 November 2008 04:02

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And privileges.

Regards
Michel

Report message to a moderator

Previous Topic:	Case Expression
Next Topic:	Find a break in number sequence

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 12:51:16 CST 2025