Home » Server Options » Replication » Repication through Trigger
Repication through Trigger [message #280195] Mon, 12 November 2007 14:33 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
Has any body done table level replication through trigger method on a remote database.

Thanks
Re: Repication through Trigger [message #280196 is a reply to message #280195] Mon, 12 November 2007 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't use snapshot (or Streams)?
It is built-in.
It is reliable.
It is supported.
It will upgrade with Oracle version.
You don't have to design.
You don't have to care about concurrency.
You don't have to code.
You don't have to maintain the code.

Why code something that is already there and debugged for years by dozen of people?
Do you think you can do it better?

Regards
Michel

[Updated on: Mon, 12 November 2007 14:40]

Report message to a moderator

Re: Repication through Trigger [message #280438 is a reply to message #280196] Tue, 13 November 2007 10:34 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I cannot use materialised view because it is two ways replication.
Streams cannot be used as tables are not identical becuase it has sequences in columns
Re: Repication through Trigger [message #280441 is a reply to message #280438] Tue, 13 November 2007 11:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Materialized views can be used in updatable mode (two way replication).
Streams can be used even if tables are not identical, dml hanlders are there for that.

Actually, all what you can do with triggers can be done with Streams and much more.

Regards
Michel
Re: Repication through Trigger [message #280442 is a reply to message #280441] Tue, 13 November 2007 11:17 Go to previous messageGo to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I did not know, that streams can handle non identical tables, Please send the link of this doc, and this is 9i. Thanks for all your help..
Re: Repication through Trigger [message #280443 is a reply to message #280442] Tue, 13 November 2007 11:23 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B10501_01/server.920/a96571/toc.htm

Regards
Michel
Previous Topic: Issue with creation of a materialized view (merged)
Next Topic: Materialized view exceptions
Goto Forum:
  


Current Time: Thu Mar 28 14:54:05 CDT 2024