I think dbms_comparison is not part of a licenced option.
(Because It’s NOT listed in manual of “Oracle Database Licensing Information 11g Release 2 (11.2) – Oracle Database Options”.)
Maybe the difference by Version…

As it says in the footnote the indication I had about dbms_comparison (I got the name wrong originally) was that it was part of a licenced option – which is why it might be worth looking at dbms_rectifier_diff. If I’m wrong about the licensing then you could try a simple test of the code I’ve given and the equivalent for dbms_comparison to see if there are any significant differences in performance or implementation that you might care about. (You could enable extended tracing to get an idea of the code mechanisms.)

Using your own blog probably makes it easier to format your work, and adding a comment here that points to your blog would probably be a good way to make the connection.

]]>By: Stew ASHTONhttps://jonathanlewis.wordpress.com/2013/12/09/differences/#comment-61418
Mon, 09 Dec 2013 20:26:54 +0000http://jonathanlewis.wordpress.com/?p=9519#comment-61418Jonathan, what exactly do you want done? Are we supposed to just test and put results into comments?

I intend to start blogging in the next few weeks and table synchronization will be one of my topics. If no one else beats me to it, I would prefer to deal with this method in a blog post with more formatting control and more space. I would link back here of course.