ORACLE-L
Subject: Re:RE: Comparing data between two tables in two schema
Why not try the time tested brute force method?
Select * from owner1.table1
intersect select * from owner2.table2;
If you get the same number of rows as there are in the tables
individually then
they are equal. BTW
:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 11:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Comparing data between two tables in two schema
I think that the Change Management Pack of the Oracle
Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL
To: Multiple recipients of list ORACLE-L
Subject: Re: Comparing data between two tables in two schema
I think that the Change Management Pack of the Oracle
Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED
recipients of list ORACLE-L
Subject: Re: Comparing data between two tables in two schema
I think that the Change Management Pack of the Oracle
Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple
Agreed. A few other pluses:
3) Lowest common denominator access requirements
(e.g. If you receive a frantic call from operations when you are somewhere
that doesn't have the GUI tools you know, you can still get the job done - with
only character mode and a command line.)
4) Increased
-L
I think that the Change Management Pack of the Oracle Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Comparing data between two tables in two schema
Date: Mon, 01
;
if (cnt1 = cnt2) and (cnt2 = cnt3) then
res := 0 ;
else
res := 1 ;
end if;
return res;
end;
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Comparing data between two tables in two schema
Date
is considered rude in production environment.
-Original Message-
From: Alejandra Pazos Freire [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 11:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Comparing data between two tables in two schema
I think that the Change
: Re: Comparing data between two tables in two schema
I think that the Change Management Pack of the Oracle
Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject
recipients of list ORACLE-L
Subject: Re:RE: Comparing data between two tables in two schema
Why not try the time tested brute force method?
Select * from owner1.table1
intersect select * from owner2.table2;
If you get the same number of rows as there are in the tables
individually
List,
I have two schema. The tables in both schema are having same name and
structures.
Is there any tool to compare the data between two schema tabels?
Thanks,
Rao
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rao, Maheswara
INET: [EMAIL PROTECTED]
Fat City
If you are looking for Third Party tools then I would suggest Schema
Manager from Quest.
Rao, Maheswara wrote:
List,
I have two schema. The tables in both schema are having same name and
structures.
Is there any tool to compare the data between two schema tabels?
Thanks,
Rao
--
I think that the Change Management Pack of the Oracle Enterprise Manager may
be useful to you.
From: Rao, Maheswara [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Comparing data between two tables in two schema
Date: Mon, 01
13 matches
Mail list logo