FW: RE: RE: Comparing data between two tables in two schema
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: [EMAIL PROTECTED] === 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] === 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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 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
RE: Comparing data between two tables in two schema
Rao, I have a simple WinNT command line tool that I wrote and I have the source code for it. It generates a txt based file of one schema or of a subset of it. Then you can let it compare to an other schema or part of it. The structure of data must be the same, though the tables and columns in on schema can have different names than in the others. The result of the comparison is a SQL file that contains insert, update and delete commands to bring the second schema in sync with the data in the 'txt based export' file. It works for Oracle 8 and Oracle 8i, support data, number, char, varchar type date but no objects. You can also generate SQL*Loader files with for the schema. I use it for keeping offline user sites schemas in sync with the master database, where I can not offerd to drop the schema and recreate it by importing it, since the schema is in use 24x7 the time. Tamas Szecsy -Original Message- Sent: Tuesday, October 02, 2001 6:21 PM To: Multiple recipients of list ORACLE-L 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
RE: RE: Comparing data between two tables in two schema
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: [EMAIL PROTECTED] === 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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 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
Re:RE: RE: Comparing data between two tables in two schema
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] === 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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 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
Re: Re:RE: RE: Comparing data between two tables in two schema
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 knowledge (Someday you can write your own GUI tool, make it shareware, and, if its good enough, eventually QUEST might buy it!) -Don Granaman [OraSaurus - not yet fossilized] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 03, 2001 10:30 AM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
RE: Comparing data between two tables in two schema
If its the actual data you could look at the minus, intersect operators etc eg select * from schema1.table minus select * from schema2.table give the data in schema1 not in schema 2. Iain Nicoll -Original Message- Sent: 02 October 2001 04:15 To: Multiple recipients of list ORACLE-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 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: Nicoll, Iain (Calanais) 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).
Re: Comparing data between two tables in two schema
This function comapres two tables. It's easy to write a cycle for tables in two schemas. Enjoy it. Jan Pruner create function compare_tables( tbl1 VARCHAR2, tbl2 VARCHAR2) return NUMBER /* Function compares content of two identical tables || tbl1, tbl2 are names of tables in format owner.table_name || 2001, Jan Pruner */ AS cnt1number; cnt2number; cnt3number; res number; sql_stmtvarchar2(100); begin -- count of tuples in 1. table sql_stmt := 'select count(*) into cnt1 from :1'; EXECUTE IMMEDIATE sql_stmt USING tbl1; -- count of tuples in 2. table sql_stmt := 'select count(*) into cnt2 from :1'; EXECUTE IMMEDIATE sql_stmt USING tbl2; -- count of tuples in union of tables sql_stmt := 'select count(*) into cnt3 from ( select * from :1 UNION select * from :2) t'; EXECUTE IMMEDIATE sql_stmt USING tbl1, tbl2; 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: 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: Jan Pruner 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).
RE: Comparing data between two tables in two schema
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).
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: 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).
RE: RE: Comparing data between two tables in two schema
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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 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). -- 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
Comparing data between two tables in two schema
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).
Re: Comparing data between two tables in two schema
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 -- 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). -- Byron Pearce mailto:[EMAIL PROTECTED] Tenure Systems, Inc. Arlington, Texas It's hard to be a ninja when you wear a beeper. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Byron Pearce 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).
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).