Re: Compare a table to itself

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@xxxxxxxxxxxxxxxx
(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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Trying to set up a SQL Server Agent Account and I hit a wall....
    ... Our database is on SQL Server 2005, however it is set to compatibility mode ... You may need to set the compatibility level ... of the current database to a higher value to enable this feature. ... for the stored procedure sp_dbcmptlevel. ...
    (microsoft.public.sqlserver.security)
  • Re: OOP - a question about database access
    ... What I've decided to do is try to take a little database I have ... >and proper techniques of OOA, ... As you implement a feature, try to let the code tell you ... and delegation to help you eliminate this duplication. ...
    (comp.object)
  • Re: Oracle Streams / Change Data Capture Question
    ... we have a corporate database - our main system - which is effectively ... datasets off to the destination system. ... The question I have is whether or not a feature like 'Oracle Streams' ...
    (comp.databases.oracle.server)
  • Re: Oracle Streams / Change Data Capture Question
    ... we have a corporate database - our main system - which is effectively ... datasets off to the destination system. ... The question I have is whether or not a feature like 'Oracle Streams' ...
    (comp.databases.oracle.server)
  • Re: External tables. Security concerns.
    ... they would know that DIRECTORY OBJECTS are wholly internal to the ... Puget Sound Oracle Users Group ... from inside the database. ... In all examples that I have seen the remote location was identified as ...
    (comp.databases.oracle.server)