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
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.

Re: Oracle Streams [message #414111 is a reply to message #414108] Mon, 20 July 2009 07:10 Go to previous message
Michel Cadot
Messages: 68259
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?).

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

Current Time: Mon Aug 15 21:15:48 CDT 2022