in reply to How to Compare Data in 2 Separate Databases

AFAIK, you definitely need the dblink to be there already when accessing across databases in Oracle. But you can always just use two DataBase Handles, spool the data from both db's with the same query run on both $dbh's to two data structures in Perl, and compare those. Good Luck!

-malloc
  • Comment on Re: How to Compare Data in 2 Separate Databases

Replies are listed 'Best First'.
Re: Re: How to Compare Data in 2 Separate Databases
by hakkr (Chaplain) on Nov 30, 2001 at 15:20 UTC
    The SQL commands JOIN or UNION may make this easier for you.