Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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)Received on Sat Nov 26 2005 - 18:07:40 CST