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: it's cheap too. Dick Goulet ____________________Reply Separator____________________ Author: "Gogala; Mladen" <[EMAIL PROTECTED]> Date: 10/2/2001 7:35 AM The freware "tora" tool also has some "compare" capabilities. I've tested if with whe users "scott" and "scott1" (both populated throuh the "demobld" script and, therefore containing vast masses of data) and it worked well. I haven't tested it on a real life database, mostly because the word "freeware" 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 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 Oct 2001 12:29:41 -0800 > > > >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 Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / > Mailing Lists > >-------------------------------------------------------------------- > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > > > _________________________________________________________________ > Descargue GRATUITAMENTE MSN Explorer en > http://explorer.msn.es/intl.asp > > -- > Please see the official > ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alejandra Pazos Freire > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
