------_=_NextPart_001_01C3AAA8.95C529E0 Content-Type: text/plain; charset="iso-8859-1"
Well, I have to say the answer to both questions is probably DataBee ..... ( www.databee.com <http://www.databee.com> ) , although not via a script. Just been using it quite a bit recently, so your question elicited an immediate response. Comparison is two-part, of course - DDL and data. Databee excellent for former. On data comparisons you will need a different solution, which will depend on the size of your tables. More on that if required. peter edinburgh -----Original Message----- Sent: Thursday, November 13, 2003 7:59 PM To: Multiple recipients of list ORACLE-L I am looking for a script to compare an entire database instance against another. (From [EMAIL PROTECTED], etc). I do not want something that has to be done by schema, as I have 50+ schema's to compare. ALSO - on a side note, is there an 'easy' way of duplicating a PRODUCTION database over to test, without copying the db files? --- Michael E. Cupp, Jr. (tm)*** Email: [EMAIL PROTECTED] ** Phone: 937-255-1982 DSN 785-1982 ** Fax: 937-656-4308 DSN 986-4308 ** Location: DET 1 AFRL/WSI Bldg 45, Room 062 2130 8th St WPAFB OH 45433 ********************************************************************* This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk ********************************************************************* ------_=_NextPart_001_01C3AAA8.95C529E0 Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1106" name=GENERATOR> <STYLE>@font-face { font-family: Courier; } @font-face { font-family: Wingdings; } @font-face { font-family: Tahoma; } @font-face { font-family: Comic Sans MS; } @font-face { font-family: Webdings; } @page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline } A:visited { COLOR: purple; TEXT-DECORATION: underline } SPAN.MsoHyperlinkFollowed { COLOR: purple; TEXT-DECORATION: underline } SPAN.EmailStyle17 { COLOR: windowtext; FONT-FAMILY: Arial } DIV.Section1 { page: Section1 } </STYLE> </HEAD> <BODY lang=EN-US vLink=purple link=blue> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2>Well, I have to say the answer to both questions is probably DataBee ..... (<A href="http://www.databee.com">www.databee.com</A>) , although not via a script.</FONT></SPAN></DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2>Just been using it quite a bit recently, so your question elicited an immediate response.</FONT></SPAN></DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2>Comparison is two-part, of course - DDL and data. Databee excellent for former. On data comparisons you will need a different solution, which will depend on the size of your tables. More on that if required.</FONT></SPAN></DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2>peter</FONT></SPAN></DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2>edinburgh</FONT></SPAN></DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=315080712-14112003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <BLOCKQUOTE dir=ltr style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Cupp Michael E Contr Det 1 AFRL/WSI [mailto:[EMAIL PROTECTED]<BR><B>Sent:</B> Thursday, November 13, 2003 7:59 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Database Compare Script<BR><BR></FONT></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am looking for a script to compare an entire database instance against another. (From [EMAIL PROTECTED], etc).</SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I do not want something that has to be done by schema, as I have 50+ schema's to compare.</SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">ALSO - on a side note, is there an 'easy' way of duplicating a PRODUCTION database over to test, without copying the db files?</SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P> <P class=MsoNormal style="LINE-HEIGHT: 6pt"><FONT face=Courier color=blue size=1><SPAN style="FONT-SIZE: 8pt; COLOR: blue; FONT-FAMILY: Courier">---</SPAN></FONT></P> <P class=MsoNormal><FONT face="Comic Sans MS" color=blue size=4><SPAN style="FONT-SIZE: 13.5pt; COLOR: blue; FONT-FAMILY: 'Comic Sans MS'">Michael E. Cupp, Jr.</SPAN></FONT></P> <P class=MsoNormal><FONT face=Webdings color=blue size=3><SPAN style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Webdings">(tm)</SPAN></FONT><FONT face=Webdings color=navy><SPAN style="COLOR: navy; FONT-FAMILY: Webdings"> <FONT face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </SPAN></FONT><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma">Email: </SPAN></FONT><U><FONT face=Tahoma color=blue size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: blue; FONT-FAMILY: Tahoma">[EMAIL PROTECTED]</SPAN></FONT></U></P> <P class=MsoNormal><FONT face=Wingdings color=green size=3><SPAN style="FONT-SIZE: 12pt; COLOR: green; FONT-FAMILY: Wingdings">(</SPAN></FONT><FONT face=Wingdings color=navy><SPAN style="COLOR: navy; FONT-FAMILY: Wingdings"> <FONT face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </SPAN></FONT><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma">Phone: 937-255-1982 DSN 785-1982</SPAN></FONT></P> <P class=MsoNormal><FONT face=Wingdings color=maroon size=3><SPAN style="FONT-SIZE: 12pt; COLOR: maroon; FONT-FAMILY: Wingdings">2</SPAN></FONT><FONT face=Wingdings color=navy><SPAN style="COLOR: navy; FONT-FAMILY: Wingdings"> <FONT face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </SPAN></FONT><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma">Fax: 937-656-4308 DSN 986-4308</SPAN></FONT></P> <P class=MsoNormal><FONT face=Wingdings color=purple size=3><SPAN style="FONT-SIZE: 12pt; COLOR: purple; FONT-FAMILY: Wingdings">-</SPAN></FONT><FONT face=Wingdings color=navy><SPAN style="COLOR: navy; FONT-FAMILY: Wingdings"> <FONT face="Courier New"></FONT><FONT face="Courier New"></FONT><FONT FACE="Courier New"></FONT> </SPAN></FONT><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma">Location: DET 1 AFRL/WSI</SPAN></FONT></P> <P class=MsoNormal><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma"> Bldg 45, Room 062</SPAN></FONT></P> <P class=MsoNormal><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma"> </SPAN></FONT><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma">2130 8th St</SPAN></FONT></P> <P class=MsoNormal><FONT face=Tahoma color=navy size=1><SPAN style="FONT-SIZE: 8.5pt; COLOR: navy; FONT-FAMILY: Tahoma"> WPAFB OH 45433</SPAN></FONT></P> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE><FONT SIZE=3><BR> <BR> *********************************************************************<BR> This e-mail message, and any files transmitted with it, are<BR> confidential and intended solely for the use of the addressee. If<BR> this message was not addressed to you, you have received it in error<BR> and any copying, distribution or other use of any part of it is<BR> strictly prohibited. Any views or opinions presented are solely those<BR> of the sender and do not necessarily represent those of the British<BR> Geological Survey. The security of e-mail communication cannot be<BR> guaranteed and the BGS accepts no liability for claims arising as a<BR> result of the use of this medium to transmit messages from or to the<BR> BGS. . http://www.bgs.ac.uk<BR> *********************************************************************<BR> </FONT> </BODY></HTML> ------_=_NextPart_001_01C3AAA8.95C529E0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).