Re: Data Comparison

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)