Re: script or utility to generate dml comparing two schemas

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@xxxxxxxxxxxxx>                                                       
                      <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@xxxxxxxxxxxxx
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
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: