| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Compare Script
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_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 system_at_instance, 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: michael.cupp_at_wpafb.af.mil
** 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:Michael.Cupp_at_wpafb.af.mil]<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
system_at_instance, 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">michael.cupp_at_wpafb.af.mil</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: pgro_at_bgs.ac.uk
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: ListGuru_at_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).
Received on Fri Nov 14 2003 - 06:16:15 CST
 |
 |