OraFAQ Forum: Replication » About Replication

Home » Server Options » Replication » About Replication

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

About Replication [message #615830]

Mon, 09 June 2014 14:24

compuscience
Messages: 93
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?

Report message to a moderator

Re: About Replication [message #615831 is a reply to message #615830]

Mon, 09 June 2014 14:35

Michel Cadot
Messages: 67648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

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

Report message to a moderator

Re: About Replication [message #615832 is a reply to message #615831]

Mon, 09 June 2014 14:40

compuscience
Messages: 93
Registered: September 2012

Member

i mean that
one of the table i need to alter it without affected on the replication process

Report message to a moderator

Re: About Replication [message #615833 is a reply to message #615832]

Mon, 09 June 2014 14:45

Michel Cadot
Messages: 67648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What do you mean by "alter"?

Report message to a moderator

Re: About Replication [message #615834 is a reply to message #615833]

Mon, 09 June 2014 14:50

compuscience
Messages: 93
Registered: September 2012

Member

sir
i need to alter table to modify one of it's column

Report message to a moderator

Re: About Replication [message #615835 is a reply to message #615834]

Mon, 09 June 2014 16:52

John Watson
Messages: 8457
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.

Report message to a moderator

Re: About Replication [message #615851 is a reply to message #615835]

Tue, 10 June 2014 02:26

compuscience
Messages: 93
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

Report message to a moderator

Re: About Replication [message #615852 is a reply to message #615851]

Tue, 10 June 2014 02:53

John Watson
Messages: 8457
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

Report message to a moderator

Re: About Replication [message #617468 is a reply to message #615852]

Mon, 30 June 2014 07:16

compuscience
Messages: 93
Registered: September 2012

Member

Dear Sir,
What is the syntax which can i write to do it?

Report message to a moderator

Re: About Replication [message #617474 is a reply to message #617468]

Mon, 30 June 2014 07:29

John Watson
Messages: 8457
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.

Report message to a moderator

Previous Topic:	Database refresh using different tools
Next Topic:	SQL Server to Oracle Replication - Golden gate - Checkpoint info and backup queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 20 14:44:36 CST 2021