Home » Server Options » Replication » Oracle Streams (Oracle 10g)
Oracle Streams [message #414108] Mon, 20 July 2009 07:08 Go to next message
vishal gupta
Messages: 111
Registered: March 2001
Senior Member
Hi,
We are using Oracle Streams for replication.

Column datatypes in some of the tables on Source and Destination are different (Number on Source and Varchar2 on destination).

Do we have to create any rule or dml handler to handle this or Streams will automatically take care of it?

We are oracle 10g.

regards
Re: Oracle Streams [message #414111 is a reply to message #414108] Mon, 20 July 2009 07:10 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As there is an implicit conversion from number to varchar2 you have not to create a rule but it should be better if you want a specific format (otherwise why the datatype are distinct?).

Regards
Michel
Previous Topic: Gather Statistics on Materialized views
Next Topic: Selective incremental replication between two instances?
Goto Forum:
  


Current Time: Sat Dec 10 16:30:54 CST 2016

Total time taken to generate the page: 0.10540 seconds