| Oracle Streams [message #414108] |
Mon, 20 July 2009 07:08  |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
