Re: Compare data between 2 tables (same columns) in different schemas

It makes sense.
This task is not usual.
I need to do only once. I can choose tables or wait for comparison of all tables.
The activity is a double check after apply : flashback database to restore point rbk001;

Thanks
Eriovaldo

2015-08-17 11:13 GMT-03:00 Adams, Matthew (GE Appliances) <MATT.ADAMS_at_ge.com
>:

> DBMS_COMPARISON will do what you want (even will do it across DBs using
> dblinks).
>
>
>
> However, think about what you’re asking for. If you’re comparing the data
> in table1 and table2, and neither have a primary or unique key, you’re
> going to end up with a Cartesian product. For every row read in table1,
> it’s going to have to do a full table scan to find whether or not the row
> exists in table2. Not an optimal solution for any size table except
> very small.
>
>
>
> Matt
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Eriovaldo Andrietta
> *Sent:* Monday, August 10, 2015 12:33 PM
> *To:* ORACLE-L
> *Subject:* Compare data between 2 tables (same columns) in different
> schemas
>
>
>
> Is there any Oracle resource to compare data between 2 tables (same
> columns) in different schemas ?
>
>
>
> I use PL/SQL Developer. It does it.
>
> But it requests a primary key in the table. Some tables does not have it.
>
>
>
> Regards
>
> Eriovaldo
>
>
>

--
http://www.freelists.org/webpage/oracle-l