Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Data Comparison

Re: Data Comparison

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 26 Nov 2005 16:07:40 -0800
Message-ID: <1133050056.28397@yasure>


raghu wrote:
> Hi,
>
> We are trying to compare the data of two tables of the same structure.
> In other words, the missing and the different records have to be
> determined. The database being used is Oracle 9i. The options I am
> currently evaluating are
>
> 1. Minus Operator - Since the table has nearly 4 million records, I am
> not sure if this is a feasible option.
>
> 2. Cursors - For each of the tables, cursors can be opened and then the
> data can be compared. But the data cannot be fetched in blocks (using
> the BULK COLLECT LIMIT option), since different records can be fetched
> for each table.
>
> Though the time taken for the comparison is not a constraint, the
> number of hits to database and the processing memory certainly needs to
> be considered.
>
> What are your thoughts? Are there any other mechanisms for comparison?
>
> Thank you.

Don't reinvent the wheel ... use the dbms_rectifier_diff built-in package.

www.psoug.org
click on Morgan's Library

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Nov 26 2005 - 18:07:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US