Charles Hooper wrote:
> DA Morgan wrote:
>> Newkid wrote:
>>> Hi there!
>>>
>>> Please guide me how to compare a table to itself. Problem is like this:
>>>
>> Use the DBMS_RECTIFIER_DIFF built-in package. It is documented at
>> http://tahiti.oracle.com and there are demos in Morgan's Library
>> at www.psoug.org.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org
>
> That looks like an interesting package - always looking for better ways
> to produce output.
>
> The search feature in the 10g R2 online documentation took me here:
> http://www.oracle.com/pls/db102/search?remark=quick_search&word=DBMS_RECTIFIER_DIFF+&tab_id=
>
> First link lead me to this page:
> http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_recdif.htm
> "The DBMS_RECTIFIER_DIFF package provides an interface used to detect
> and resolve data inconsistencies between two replicated sites."
>
> And then to this page:
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14227/rarmanage.htm
> "Oracle Database Advanced Replication Management API Reference 10g
> Release 2 (10.2)"
>
> Is this an Enterprise Edition only package (Advanced Replication)?
> This reminds me of a couple books that I read about four years ago that
> discussed the merits of virtual private databases to help hide
> information in the database from a group of database users, and
> partitioning to improve performance. The books that discuss these
> features rarely discuss that the features require the Enterprise
> Edition of Oracle, or the Enterprise Edition And the purchase of an
> additional feature.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
It was introduced as a utility for Advanced Replication. But while I
have no use for AR I find great value in DBMS_RECTIFIER_DIFF for many
purposes such as Data Guard and Streams.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Jul 22 2006 - 19:07:36 CDT