RE: Schema Compare and Synonyms
John Dorlon <[email protected]> Wed, 17 Apr 2013 15:38:29 +0000
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <4120B436C765EC43A31CC3E2A13D36A6264350CE@ALVMBXW02.prod.quest.corp> |
--_000_4120B436C765EC43A31CC3E2A13D36A6264350CEALVMBXW02prodqu_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable The schema compare is smart enough to ignore the fact that the schemas have= different names. The side by side viewer is not. So don't be fooled by t= he side by side viewer highlighting the schema names (unless of course the = highlighted schema is not one that is being compared, and is a true differe= nce). If a trigger is created with the schema name, that schema name will make it= into the trigger's source. If the trigger is created without the schema n= ame, there will be no schema name in the trigger's source. Toad sometimes = has to inject or remove the schema name when building 'create trigger' scri= pts depending on a) if your options are configured to include schema name, = b) if the schema name is present in the source, and c) if your options are = configured for Toad to add or remove the schema name (this is the "parse tr= iggers for schema name" option). =D8 Is the difference that the target objects are owned by different schem= as NOKALG and OLIALG? Yes, I believe that is what is causing the difference. From: [email protected] [mailto:[email protected]] On Behalf Of Reed,= David A. Sent: Wednesday, April 17, 2013 10:20 AM To: [email protected] Subject: [toad] RE: Schema Compare and Synonyms John/Bert: I am beginning to know Schema Compare better. * In the NOKPROK/OLIPROC schemas comparison, I see only 2 triggers = with description differences. When I look at the difference details, I see= the schema names present in the CREATE OR REPLACE statements causing the d= ifference. But when I go to the source tabs for the triggers in each schem= a, the schema names are not present. To add to the strangeness none of the= other triggers shows description differences. * None of the synonyms are public. But what you state may be the i= ssue. I am comparing NOKPROC (source) to OLIPROC (target). One of the syn= onyms is NOKPROC.ALG_ACT_CONFIG. Its target object is NOKALG.ALG_ACT_CONFI= G (a table). The corresponding synonym is OLIPROC.ALG_ACT_CONFIG. Its tar= get object is OLIALG.ALG_ACT_CONFIG (a table). Is the difference that the = target objects are owned by different schemas NOKALG and OLIALG? I don't s= ee however, the reverse: the same OLIPROC synonyms not being present in N= OKPROC. * The constraint issue is that the comparison uses generating scrip= ts that include the schema names. This results in the difference. It woul= d be nice to have an option to not include the schema names when comparing = generating scripts. Regards, Dave From: [email protected]<mailto:[email protected]> [mailto:toad@yahoog= roups.com] On Behalf Of John Dorlon Sent: Wednesday, April 17, 2013 10:08 AM To: [email protected]<mailto:[email protected]> Subject: [toad] RE: Schema Compare and Synonyms Yes, in the schema compare window, options tab, object type specific option= s, in the "PL/SQL Objects and View Source" groupbox, there are all kinds of= things like that. From: [email protected]<mailto:[email protected]> [mailto:toad@yahoog= roups.com] On Behalf Of Bert Scalzo Sent: Wednesday, April 17, 2013 9:04 AM To: [email protected]<mailto:[email protected]> Subject: [toad] RE: Schema Compare and Synonyms On #1 is there also not an option to ignore spaces and things when comparin= g that text ??? From: [email protected]<mailto:[email protected]> [mailto:toad@yahoog= roups.com] On Behalf Of John Dorlon Sent: Wednesday, April 17, 2013 8:59 AM To: [email protected]<mailto:[email protected]> Subject: [toad] RE: Schema Compare and Synonyms Hi David, The word 'description' here refers to the data in the dba_triggers.descri= ption column. When you create the trigger, some of your 'create' statemen= t ends up in there. It is basically everything before the body of the trig= ger. If you rt-click on the trigger in the schema compare results and choo= se "show difference details", the DDL for the two triggers (one from each s= chema) will appear in the side-by-side file compare window. Synonyms: Is the synonym owner or name different between the two schemas= ? Public in one schema, private in the other? Constraint: Look in dba_constraints for the rows of the constraints in q= uestion, particularly at the r_owner and r_constraint_name columns. Also = check the table name that the R_CONSTRAINT_NAME constraint is one. That be= ing different could also raise this. I hope that helps. - John From: [email protected]<mailto:[email protected]> [mailto:toad@yahoog= roups.com] On Behalf Of Reed, David A. Sent: Wednesday, April 17, 2013 8:25 AM To: [email protected]<mailto:[email protected]> Subject: [toad] Schema Compare and Synonyms Yesterday I used Schema Compare from 11.6.1.1 to look at the differences be= tween 2 similar schemas and have several issues. * Schema Compare is showing triggers that differ by the "descriptio= n". How can I look at it using Toad? We don't assign it a value. Does a = default value get assigned? * Schema Compare is showing synonyms missing between the two schema= s, particularly in the source not found in the target. However, when I loo= k at the target, they exist. What are the criteria for synonyms not being = present? * Schema Compare is showing constraints that differ by "foreign key= ". What does that mean? When I look at the two constraints, I see no diff= erences. Thanks in advance, Dave David Reed Principal Engineer Strategy and Project Support Design Standardization & Process Leadership CWHQ2 318D Westinghouse Electric Company Suite 251 1000 Westinghouse Drive Cranberry Township PA 16066, USA Phone: +1 (412) 374-6739 Fax: +1 (412) 374-4575 Email: [email protected]<mailto:[email protected]> Home Page: www.westinghousenuclear.com --_000_4120B436C765EC43A31CC3E2A13D36A6264350CEALVMBXW02prodqu_ Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <head> <style type=3D"text/css"> <!-- /* start of attachment style */ .ygrp-photo-title{ clear: both; font-size: smaller; height: 15px; overflow: hidden; text-align: center; width: 75px; } div.ygrp-photo{ background-position: center; background-repeat: no-repeat; background-color: white; border: 1px solid black; height: 62px; width: 62px; } div.photo-title=20 a, div.photo-title a:active, div.photo-title a:hover, div.photo-title a:visited { text-decoration: none;=20 } div.attach-table div.attach-row { clear: both; } div.attach-table div.attach-row div { float: left; /* margin: 2px;*/ } p { clear: both; padding: 15px 0 3px 0; overflow: hidden; } div.ygrp-file { width: 30px; valign: middle; } div.attach-table div.attach-row div div a { text-decoration: none; } div.attach-table div.attach-row div div span { font-weight: normal; } div.ygrp-file-title { font-weight: bold; } /* end of attachment style */ --> </style> </head> <html> <head> <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-= 1"> <meta name=3D"Generator" content=3D"Microsoft Word 14 (filtered medium)"> <!--[if !mso]><style>v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style><![endif]--><style><!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4;} @font-face {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} @font-face {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman","serif";} a:link, span.MsoHyperlink {mso-style-priority:99; color:blue; text-decoration:underline;} a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:purple; text-decoration:underline;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} code {mso-style-priority:99; font-family:"Courier New";} pre {mso-style-priority:99; mso-style-link:"HTML Preformatted Char"; margin:0in; margin-bottom:.0001pt; font-size:10.0pt; font-family:"Courier New";} tt {mso-style-priority:99; font-family:"Courier New";} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate {mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0in; margin-bottom:.0001pt; font-size:8.0pt; font-family:"Tahoma","sans-serif";} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.cat {mso-style-name:cat;} span.ct {mso-style-name:ct;} span.HTMLPreformattedChar {mso-style-name:"HTML Preformatted Char"; mso-style-priority:99; mso-style-link:"HTML Preformatted"; font-family:Consolas;} p.attach, li.attach, div.attach {mso-style-name:attach; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:9.0pt; font-family:"Arial","sans-serif";} p.bold, li.bold, div.bold {mso-style-name:bold; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:10.0pt; font-family:"Arial","sans-serif"; font-weight:bold;} p.green, li.green, div.green {mso-style-name:green; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; color:#628C2A;} p.replbq, li.replbq, div.replbq {mso-style-name:replbq; margin:3.0pt; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad, li.ad, div.ad {mso-style-name:ad; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline, li.underline, div.underline {mso-style-name:underline; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} span.yshortcuts {mso-style-name:yshortcuts;} p.ad1, li.ad1, div.ad1 {mso-style-name:ad1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.ad2, li.ad2, div.ad2 {mso-style-name:ad2; mso-margin-top-alt:auto; margin-right:0in; margin-bottom:7.5pt; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif";} p.underline1, li.underline1, div.underline1 {mso-style-name:underline1; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; font-size:12.0pt; font-family:"Times New Roman","serif"; text-decoration:underline;} span.yshortcuts1 {mso-style-name:yshortcuts1; font-family:"Verdana","sans-serif"; font-weight:bold;} span.yshortcuts2 {mso-style-name:yshortcuts2; font-family:"Verdana","sans-serif"; font-weight:normal;} span.EmailStyle37 {mso-style-type:personal-reply; font-family:"Calibri","sans-serif"; color:#1F497D;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-priority:99; mso-style-link:"Balloon Text"; font-family:"Tahoma","sans-serif";} .MsoChpDefault {mso-style-type:export-only; font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:1336803494; mso-list-template-ids:1082429674;} @list l0:level1 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Symbol;} @list l0:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:"Courier New"; mso-bidi-font-family:"Times New Roman";} @list l0:level3 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level4 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level5 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level6 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level7 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level8 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l0:level9 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in; mso-ansi-font-size:10.0pt; font-family:Wingdings;} @list l1 {mso-list-id:1668315921; mso-list-type:hybrid; mso-list-template-ids:-670933276 -1504947682 67698691 67698693 67698689 67= 698691 67698693 67698689 67698691 67698693;} @list l1:level1 {mso-level-start-at:6; mso-level-number-format:bullet; mso-level-text:\F0D8; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Wingdings; mso-fareast-font-family:Calibri; mso-bidi-font-family:"Times New Roman";} @list l1:level2 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:"Courier New";} @list l1:level3 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Wingdings;} @list l1:level4 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Symbol;} @list l1:level5 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:"Courier New";} @list l1:level6 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Wingdings;} @list l1:level7 {mso-level-number-format:bullet; mso-level-text:\F0B7; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Symbol;} @list l1:level8 {mso-level-number-format:bullet; mso-level-text:o; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:"Courier New";} @list l1:level9 {mso-level-number-format:bullet; mso-level-text:\F0A7; mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in; font-family:Wingdings;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --></style><!--[if gte mso 9]><xml> <o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" /> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext=3D"edit"> <o:idmap v:ext=3D"edit" data=3D"1" /> </o:shapelayout></xml><![endif]--> </head> <body bgcolor=3D"white" lang=3D"EN-US" link=3D"blue" vlink=3D"purple"> <div class=3D"WordSection1"> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D">The schema compare is sma= rt enough to ignore the fact that the schemas have different names. T= he side by side viewer is not. So don’t be fooled by the side by side viewer highlighting the schema names (unless of course the highlig= hted schema is not one that is being compared, and is a true difference).<o= :p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D">If a trigger is created w= ith the schema name, that schema name will make it into the trigger’s= source. If the trigger is created without the schema name, there will be no schema name in the trigger’s source. Toad sometimes= has to inject or remove the schema name when building ‘create trigge= r’ scripts depending on a) if your options are configured to include = schema name, b) if the schema name is present in the source, and c) if your options are configured for Toad to add or remove the schema= name (this is the “parse triggers for schema name” option).<o:= p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <p class=3D"MsoListParagraph" style=3D"margin-left:.5in;text-indent:-.25in;= mso-list:l1 level1 lfo2"> <![if !supportLists]><span style=3D"font-size:11.0pt;font-family:Wingdings;= color:#1F497D"><span style=3D"mso-list:Ignore">=D8<span style=3D"font:7.0pt= "Times New Roman""> </span></span></span><![endif]><span style=3D"font-size:11.0pt">Is the diff= erence that the target objects are owned by different schemas NOKALG and OL= IALG?</span><span style=3D"font-size:11.0pt;font-family:"Calibri"= ,"sans-serif";color:#1F497D"><o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D">Yes, I believe that is wh= at is causing the difference.<o:p></o:p></span></p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <p class=3D"MsoNormal"><span style=3D"font-size:11.0pt;font-family:"Ca= libri","sans-serif";color:#1F497D"><o:p> </o:p></span><= /p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in = 0in 0in"> <p class=3D"MsoNormal"><b><span style=3D"font-size:10.0pt;font-family:"= ;Tahoma","sans-serif"">From:</span></b><span style=3D"font-s= ize:10.0pt;font-family:"Tahoma","sans-serif""> toad@yah= oogroups.com [mailto:[email protected]] <b>On Behalf Of </b>Reed, David A.<br> <b>Sent:</b> Wednesday, April 17, 2013 10:20 AM<br> <b>To:</b> [email protected]<br> <b>Subject:</b> [toad] RE: Schema Compare and Synonyms<o:p></o:p></span></p= > </div> </div> <p class=3D"MsoNormal"><o:p> </o:p></p> <p class=3D"MsoNormal"> <o:p></o:p></p> <div id=3D"ygrp-mlmsg"> <div id=3D"ygrp-msg"> <div id=3D"ygrp-text"> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt">John/Bert:</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt"> </span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt">I am beginning to know Schema Com= pare better.</span><o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-size:11.0pt;font-family:S= ymbol">=B7</span><span style=3D"font-size:7.0pt"> &n= bsp; </span><span style=3D"font-size:11.0pt">In the NOKPROK/OLIPROC schemas comp= arison, I see only 2 triggers with description differences. When I lo= ok at the difference details, I see the schema names present in the CREATE = OR REPLACE statements causing the difference. But when I go to the source tabs for the triggers in each schema, the sche= ma names are not present. To add to the strangeness none of the other= triggers shows description differences.</span><o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-size:11.0pt;font-family:S= ymbol">=B7</span><span style=3D"font-size:7.0pt"> &n= bsp; </span><span style=3D"font-size:11.0pt">None of the synonyms are public.&nb= sp; But what you state may be the issue. I am comparing NOKPROC (sour= ce) to OLIPROC (target). One of the synonyms is NOKPROC.ALG_ACT_CONFI= G. Its target object is NOKALG.ALG_ACT_CONFIG (a table). The corresponding synonym is OLIPROC.ALG_ACT_CONFIG. I= ts target object is OLIALG.ALG_ACT_CONFIG (a table). Is the differenc= e that the target objects are owned by different schemas NOKALG and OLIALG?= I don’t see however, the reverse: the same OLIPROC synonyms not being present in NOKPROC.</span><o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-size:11.0pt;font-family:S= ymbol">=B7</span><span style=3D"font-size:7.0pt"> &n= bsp; </span><span style=3D"font-size:11.0pt">The constraint issue is that the co= mparison uses generating scripts that include the schema names. This = results in the difference. It would be nice to have an option to not = include the schema names when comparing generating scripts.</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt">Regards,</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt">Dave</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt"> </span><o:p></o:p></p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:0in 0in 0i= n 0in"> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><b><span style=3D"font-size:10.0pt">From:</span></b><span style=3D= "font-size:10.0pt"> <a href=3D"mailto:[email protected]">[email protected]</a> [<a href= =3D"mailto:[email protected]">mailto:[email protected]</a>] <b>On Behalf Of </b>John Dorlon<br> <b>Sent:</b> Wednesday, April 17, 2013 10:08 AM<br> <b>To:</b> <a href=3D"mailto:[email protected]">[email protected]</a>= <br> <b>Subject:</b> [toad] RE: Schema Compare and Synonyms</span><o:p></o:p></p= > </div> </div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <div id=3D"ygrp-mlmsg"> <div id=3D"ygrp-msg"> <div id=3D"ygrp-text"> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D">Yes, in the schema = compare window, options tab, object type specific options, in the “PL= /SQL Objects and View Source” groupbox, there are all kinds of things like that.</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:0in 0in 0i= n 0in"> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><b><span style=3D"font-size:10.0pt">From:</span></b><span style=3D= "font-size:10.0pt"> <a href=3D"mailto:[email protected]">[email protected]</a> [<a href= =3D"mailto:[email protected]">mailto:[email protected]</a>] <b>On Behalf Of </b>Bert Scalzo<br> <b>Sent:</b> Wednesday, April 17, 2013 9:04 AM<br> <b>To:</b> <a href=3D"mailto:[email protected]">[email protected]</a>= <br> <b>Subject:</b> [toad] RE: Schema Compare and Synonyms</span><o:p></o:p></p= > </div> </div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <div id=3D"ygrp-mlmsg"> <div id=3D"ygrp-msg"> <div id=3D"ygrp-text"> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D">On #1 is there also= not an option to ignore spaces and things when comparing that text ???</sp= an><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:0in 0in 0i= n 0in"> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><b><span style=3D"font-size:10.0pt">From:</span></b><span style=3D= "font-size:10.0pt"> <a href=3D"mailto:[email protected]">[email protected]</a> [<a href= =3D"mailto:[email protected]">mailto:[email protected]</a>] <b>On Behalf Of </b>John Dorlon<br> <b>Sent:</b> Wednesday, April 17, 2013 8:59 AM<br> <b>To:</b> <a href=3D"mailto:[email protected]">[email protected]</a>= <br> <b>Subject:</b> [toad] RE: Schema Compare and Synonyms</span><o:p></o:p></p= > </div> </div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <div id=3D"ygrp-mlmsg"> <div id=3D"ygrp-msg"> <div id=3D"ygrp-text"> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D">Hi David,</span><o:= p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> The word = 216;description’ here refers to the data in the dba_triggers.descript= ion column. When you create the trigger, some of your ‘create’ statement ends up in there. It is basically eve= rything before the body of the trigger. If you rt-click on the trigge= r in the schema compare results and choose “show difference details&#= 8221;, the DDL for the two triggers (one from each schema) will appear in the side-by-side file compare window.</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> Synonyms:&nb= sp; Is the synonym owner or name different between the two schemas? &= nbsp;Public in one schema, private in the other?</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> Constraint:&= nbsp; Look in dba_constraints for the rows of the constraints in question, = particularly at the r_owner and r_constraint_name columns. Also check the table name that the R_CONSTRAINT_NAME = constraint is one. That being different could also raise this. </span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> I hope that = helps. </span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D">- John</span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span>= <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:11.0pt;color:#1F497D"> </span><o:p><= /o:p></p> <div> <div style=3D"border:none;border-top:solid #B5C4DF 1.0pt;padding:0in 0in 0i= n 0in"> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><b><span style=3D"font-size:10.0pt">From:</span></b><span style=3D= "font-size:10.0pt"> <a href=3D"mailto:[email protected]">[email protected]</a> [<a href= =3D"mailto:[email protected]">mailto:[email protected]</a>] <b>On Behalf Of </b>Reed, David A.<br> <b>Sent:</b> Wednesday, April 17, 2013 8:25 AM<br> <b>To:</b> <a href=3D"mailto:[email protected]">[email protected]</a>= <br> <b>Subject:</b> [toad] Schema Compare and Synonyms</span><o:p></o:p></p> </div> </div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <div id=3D"ygrp-mlmsg"> <div id=3D"ygrp-msg"> <div id=3D"ygrp-text"> <div> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto">Yesterday I used Schema Compare from 11.6.1.1 to look at the diffe= rences between 2 similar schemas and have several issues.<o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-family:Symbol">=B7</span>= <span style=3D"font-size:7.0pt"> &= nbsp; </span>Schema Compare is showing triggers that differ by the “descrip= tion”. How can I look at it using Toad? We don’t as= sign it a value. Does a default value get assigned?<o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-family:Symbol">=B7</span>= <span style=3D"font-size:7.0pt"> &= nbsp; </span>Schema Compare is showing synonyms missing between the two schemas, = particularly in the source not found in the target. However, when I l= ook at the target, they exist. What are the criteria for synonyms not= being present?<o:p></o:p></p> <p class=3D"MsoListParagraph"><span style=3D"font-family:Symbol">=B7</span>= <span style=3D"font-size:7.0pt"> &= nbsp; </span>Schema Compare is showing constraints that differ by “foreign = key”. What does that mean? When I look at the two constra= ints, I see no differences.<o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto">Thanks in advance,<o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto">Dave<o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><b><span style=3D"color:black">David Reed</span></b><o:p></o:p></p= > <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Principal Engineer</s= pan><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Strategy and Project = Support</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Design Standardizatio= n & Process Leadership</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">CWHQ2 318D</span><o:p= ></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"color:black"> </span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Westinghouse Electric= Company</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Suite 251</span><o:p>= </o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">1000 Westinghouse Dri= ve</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Cranberry Township PA= 16066, USA</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Phone: +1 (= 412) 374-6739</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Fax: +1 (41= 2) 374-4575</span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Email: <a href=3D"mailto:[email protected]">[email protected]</a></spa= n><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"><span style=3D"font-size:10.0pt;color:black">Home Page: <a href=3D"www.westinghousenuclear.com"><span style=3D"color:black">www.wes= tinghousenuclear.com</span></a></span><o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> <p class=3D"MsoNormal" style=3D"mso-margin-top-alt:auto;mso-margin-bottom-a= lt:auto"> <o:p></o:p></p> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div> <p class=3D"MsoNormal"><span style=3D"color:white"><o:p></o:p></span></p> </div> </div> <!-- |**|begin egp html banner|**| --> <br> =20=20=20=20 =20=20=20=20 <br> <!-- |**|end egp html banner|**| --> <div width=3D"1" style=3D"color: white; clear: both;"/>__._,_.___</div> <!-- Start Recommendations --> <!-- End Recommendations --> <!-- |**|begin egp html banner|**| --> <img src=3D"http://geo.yahoo.com/serv?s=3D97476590/grpId=3D1103546/grpspI= d=3D1705115368/msgId=3D58471/stime=3D1366213112" width=3D"1" height=3D"1"> = <br> <!-- |**|end egp html banner|**| --> =20=20=20=20 <!-- |**|begin egp html banner|**| --> <br> <div style=3D"font-family: verdana; font-size: 77%; border-top: 1px s= olid #666; padding: 5px 0;" > Your email settings: Individual Email|Traditional <br> <a href=3D"http://groups.yahoo.com/group/toad/join;_ylc=3DX3oDMTJmdDZ= wM2x1BF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdH= IEc2xrA3N0bmdzBHN0aW1lAzEzNjYyMTMxMTI-">Change settings via the Web</a> (Ya= hoo! ID required) <br> Change settings via email: <a href=3D"mailto:toad-digest@yahoogroups.= com?subject=3DEmail Delivery: Digest">Switch delivery to Daily Digest</a> |= <a href =3D "mailto:[email protected]?subject=3DChange Del= ivery Format: Fully Featured">Switch to Fully Featured</a> <br> <a href=3D"http://groups.yahoo.com/group/toad;_ylc=3DX3oDMTJkbm9= qdjJwBF9TAzk3NDc2NTkwBGdycElkAzExMDM1NDYEZ3Jwc3BJZAMxNzA1MTE1MzY4BHNlYwNmdH= IEc2xrA2hwZgRzdGltZQMxMzY2MjEzMTEy"> Visit Your Group=20 </a> | <a href=3D"http://docs.yahoo.com/info/terms/"> Yahoo! Groups Terms of Use </a> | <a href=3D"mailto:[email protected]?subject=3DUnsubscr= ibe"> Unsubscribe=20 </a>=20 <br> </div> <br> <!-- |**|end egp html banner|**| --> <div style=3D"color: white; clear: both;"/>__,_._,___</div> </body> </html> --_000_4120B436C765EC43A31CC3E2A13D36A6264350CEALVMBXW02prodqu_--