From mark@cool-tools.co.uk Thu, 04 Oct 2001 00:42:55 -0700 From: "Mark Leith" Date: Thu, 04 Oct 2001 00:42:55 -0700 Subject: FW: RE: RE: Comparing data between two tables in two schema In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain Dick, Oh I agree totally - when it is simple to do something by code, it is most always a far better option. I have a wealth of tools available to me with the job I am in - but almost always try use a command interface instead just so that I can broaden my database knowledge, and also have a more in-depth knowledge in to what our tools are doing in the background on these databases. The one thing with the GUI is that they are extremely useful for "newbies", and often act as learning tools. A LOT of the information I have learned about databases up until now is actually through using our tools. Other benefits, like with performance monitoring for example, are that they provide a far more intuitive interface for getting to the root of a problem when trying to diagnose something quickly.. It is far easier for somebody to glance at screen of pretty graphs that are there all the time, than to set off a bunch of scripts, and try to wade through the output.. Especially when some people can loose thousands a minute from down time. Then there is the other breed of tool that people just simply CANNOT do without - as it is just SO hard to do with conventional coding. Such as - have you ever tried extracting a logically intact subset of data from a large schema, without duplicate rows? Hard isn't it? http://www.cool-tools.co.uk/full_databee.htm This "GUI" makes light work of the task.. And I would hate to think of the PL/SQL hell you would have to get in to, to achieve the same result.. Probably faster as well.. Sorry about the plug - I'm just trying to get the point across that tools ARE/CAN be of use to even the most experienced DBA at times. I personally find this a fairly wide misconception.. Mark =================================================== Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: mark@cool-tools.co.uk =================================================== http://www.cool-tools.co.uk Maximising throughput & performance -----Original Message----- Sent: Wednesday, October 03, 2001 15:07 To: Mark Leith; Multiple recipients of list ORACLE-L GUI's are ok, I do use and appreciate then, but sometimes the older methods are 1) faster and 2) more rewarding. Especially for an old fossil, like me. Dick Goulet ____________________Reply Separator____________________ Author: "Mark Leith" Date: 10/3/01 3:25 AM Now now, GUI tools aren't all THAT bad! :P Mark (GUI tool sales critter) Leith =================================================== Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: mark@cool-tools.co.uk =================================================== http://www.cool-tools.co.uk Maximising throughput & performance -----Original Message----- Mladen Sent: Tuesday, October 02, 2001 17:50 To: Multiple recipients of list ORACLE-L That is not elegant and doesn't have a GOOEY interface. It also requires the knowledge of SQL, which is a lot to ask from a poor little DBA like me. > -----Original Message----- > From: dgoulet@vicr.com [mailto:dgoulet@vicr.com] > Sent: Tuesday, October 02, 2001 12:21 PM > To: Multiple 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 . > intersect select * from .; > > 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" > 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:alepazosfreire2@hotmail.com] > > 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" > > >Reply-To: ORACLE-L@fatcity.com > > >To: Multiple recipients of list ORACLE-L > > >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: Maheswara.Rao@Sungardp3.com > > > > > >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: ListGuru@fatcity.com (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: alepazosfreire2@hotmail.com > > > > 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: ListGuru@fatcity.com (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: MGogala@oxhp.com > > 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: ListGuru@fatcity.com (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: dgoulet@vicr.com > > 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: ListGuru@fatcity.com (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: MGogala@oxhp.com 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: ListGuru@fatcity.com (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: Mark Leith INET: mark@cool-tools.co.uk 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: ListGuru@fatcity.com (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: Mark Leith INET: mark@cool-tools.co.uk 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: ListGuru@fatcity.com (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).