Home » Server Options » Replication » About Replication
About Replication [message #615830] Mon, 09 June 2014 14:24 Go to next message
compuscience
Messages: 30
Registered: September 2012
Member
Dear Sir,
I have 2 master site replicate async. with each other
I need to alter one replicated table without affect on replication
Or without run sync. between two table again
How can i do that?
Re: About Replication [message #615831 is a reply to message #615830] Mon, 09 June 2014 14:35 Go to previous messageGo to next message
Michel Cadot
Messages: 59122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "alter one replicated table"?

Re: About Replication [message #615832 is a reply to message #615831] Mon, 09 June 2014 14:40 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
i mean that
one of the table i need to alter it without affected on the replication process
Re: About Replication [message #615833 is a reply to message #615832] Mon, 09 June 2014 14:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What do you mean by "alter"?

Re: About Replication [message #615834 is a reply to message #615833] Mon, 09 June 2014 14:50 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
sir
i need to alter table to modify one of it's column
Re: About Replication [message #615835 is a reply to message #615834] Mon, 09 June 2014 16:52 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
This is easy if you know what sort of replication you are using. Advanced Replication would use a call to dbms_repcat.alter_master_repobject, whereas Streams replication would propagate the change automatically if you set INCLUDE_DLL=TRUE. But as that defaults to FALSE, you probably didn't.

You need to provide a bit more information about your environment.
Re: About Replication [message #615851 is a reply to message #615835] Tue, 10 June 2014 02:26 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
John Watson wrote on Mon, 09 June 2014 19:52
This is easy if you know what sort of replication you are using. Advanced Replication would use a call to dbms_repcat.alter_master_repobject, whereas Streams replication would propagate the change automatically if you set INCLUDE_DLL=TRUE. But as that defaults to FALSE, you probably didn't.

You need to provide a bit more information about your environment.

how can i check the status of what you say to modify it to INCLUDE_DLL=TRUE
Re: About Replication [message #615852 is a reply to message #615851] Tue, 10 June 2014 02:53 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
You need to look at the rules that you have configured, there are several views for this. Streams can be quite complicated, you know. Have you read these yet -
http://docs.oracle.com/cd/E16655_01/server.121/e17909/toc.htm
http://docs.oracle.com/cd/E16655_01/server.121/e17910/toc.htm
http://docs.oracle.com/cd/E16655_01/server.121/e17912/toc.htm
Re: About Replication [message #617468 is a reply to message #615852] Mon, 30 June 2014 07:16 Go to previous messageGo to next message
compuscience
Messages: 30
Registered: September 2012
Member
Dear Sir,
What is the syntax which can i write to do it?
Re: About Replication [message #617474 is a reply to message #617468] Mon, 30 June 2014 07:29 Go to previous message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
Have a go yourself, and come back with any problems. Or, of course, I can ask my boss to send you a quote. I think the usual rate for ad-hoc support requests is US$250 an hour with a two hour minimum.
Previous Topic: Database refresh using different tools
Next Topic: SQL Server to Oracle Replication - Golden gate - Checkpoint info and backup queries
Goto Forum:
  


Current Time: Thu Sep 18 03:15:12 CDT 2014

Total time taken to generate the page: 0.11388 seconds