Re: script or utility to generate dml comparing two schemas

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 29 Jun 2004 08:04:39 -0400
Message-ID: <OFB7FB8CD2.C117FAAA-ON85256EC2.00420C3D@csc.com>

I use "minus". This is an example, you'd have to modify it to meet your needs.

--cmp_dbs.sql
--compare two databases as saved in the eid_roles table

needs two parameters, the dbs to compare select DATABASE, grantee, count(*) from eid_roles WHERE GRANTEE IN (SELECT GRANTEE FROM ( select grantee, count(*) from eid_roles where database = UPPER('&&1') group by grantee MINUS select grantee, count(*) from eid_roles where database = UPPER('&&2') group by grantee)) AND DATABASE IN (UPPER('&&1'),UPPER('&&2')) group by DATABASE,grantee order by 2 ,1 desc / UNDEFINE 1,2

                      "Juan Carlos                                                                                                     
                      Reyes Pacheco"           To:      <oracle-l_at_freelists.org>                                                       
                      <jreyes                  cc:                                                                                     
                      @dazasoftware.co         Subject: script or utility to generate dml comparing two schemas                        
                      m>                                                                                                               
                      Sent by:                                                                                                         
                      oracle-l-bounce                                                                                                  
                                                                                                                                       
                                                                                                                                       
                      06/28/2004 04:01                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to oracle-l

Hi list
does any one has an script or know of a utility comparing rows between two databaes or schemas and generating DML.
NOT STRUCTURE,( DDL),
please.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Tue Jun 29 2004 - 07:04:29 CDT