You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

compare data from two identical tables

2 replies [Last post]
Guest's picture
Guest

hi guys i am tryin to compare data from two identical tables E6900 and M9000 and this my DBlink ops$mis_exec.mis_sub_prof@prod
so my query is as follows i am not sure whether i am on the right track

select * from ops$mis_exec.mis_sub_prof@prod minus select * from ops$mis_exec.mis_sub_prof;

Lepa's picture
User offline. Last seen 3 weeks 20 hours ago. Offline
Joined: 06/23/2008
Posts: 565
Re: compare data from two identical tables

Are you getting any errors? You also need to make sure that the password in both environments is the same.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Ashar's picture
User offline. Last seen 4 weeks 1 day ago. Offline
Joined: 03/26/2008
Posts: 208
Re: compare data from two identical tables

You would like to look at these blog posts Compare Data in tables and Compare Data in Similar Tables

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.