# Compare schema based on invalid objects, new idea

**URL:** <https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797>\
**Category:** Toad for Oracle - Beta\
**Created:** [September 22, 2013, 8:48am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797 "2013-09-22T08:48:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [September 22, 2013, 8:48am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/1 "2013-09-22T08:48:41Z")

</div>

Hi

My Toad is 12.1.

I’d like to find how to compare number of invalid objects in two schemas.

In mine case on production there are many db links which doesn’t exists on dev. In mine cases only few directories are difference between PROD/DEV. But in practical target is unusable. This is because many packages/procs/funcs are invalid regardless their content is the same.

This mean that I have additionally compare invalid objects manually to see what else should I do.

Is there any way to implement such a compare situation… or at least place some additional button (option)?

Brg

Damir

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 23, 2013, 6:14am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/2 "2013-09-23T06:14:50Z")

</div>

There is no option in the schema compare for invalid objects…but if you aren’t expecting too many objects, the easiest way would be to open two schema browsers  
– one to each schema, and go to the “Invalid objects” tab and just eyeball it. There is a count of objects at the bottom of the screen, on the status bar.

**From:** damir.vadas\_531 [[mailto:bounce-damirvadas\_531@toadworld.com](mailto:bounce-damirvadas_531@toadworld.com)]

**Sent:** Sunday, September 22, 2013 10:49 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** [Toad for Oracle - Beta Discussion Forum] Compare schema based on invalid objects, new idea

**[Compare schema based on invalid objects, new idea](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20366.aspx)**

Thread created by damir.vadas\_531

Hi

My Toad is 12.1.

I’d like to find how to compare number of invalid objects in two schemas.

In mine case on production there are many db links which doesn’t exists on dev. In mine cases only few directories are difference and in practical target is unusable. This is because many packages  
are invalid and “not OK” regardless the content is the same.

Is there any way to implement such a compare situation… or at least place some additional button (option)?

Brg

Damir

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20366.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20366.aspx?AbuseContentId=1a2e6f20-260e-40b7-88cd-8fa6af8bdefe&AbuseContentTypeId=46448885-d0e6-4133-bbfb-f0cd7b0fd6f7&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/9e8dbd04/4V7qH6.gif)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 27, 2013, 6:03am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/3 "2013-09-27T06:03:24Z")

</div>

Anju just reminded me - you can just use the schema compare window. It includes a check on Status. The sync script will compile invalid packages in the target schema.

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [October 1, 2013, 9:47am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/4 "2013-10-01T09:47:57Z")

</div>

Hi John,

THX for your answer.

I’m sorry but looking in Schema compare window, cannot find in any of the tabs your option … Could you tell me tab name to narrow search?

Brg,

Damir

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 1, 2013, 10:05am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/5 "2013-10-01T10:05:37Z")

</div>

In the Schema Compare window, on the “Object Types to Compare” tab, check packages, procecures, functions, and whatever else you want to compare.

On the “Object Type Specific Options” tab, in the “Misc” section, is a checkbox for “Compare object status”. Check that.

**From:** damir.vadas\_531 [[mailto:bounce-damirvadas\_531@toadworld.com](mailto:bounce-damirvadas_531@toadworld.com)]

**Sent:** Tuesday, October 01, 2013 11:49 AM

**To:** [toadoraclebeta@toadworld.com](mailto:toadoraclebeta@toadworld.com)

**Subject:** RE: [Toad for Oracle - Beta Discussion Forum] Compare schema based on invalid objects, new idea

**[RE: Compare schema based on invalid objects, new idea](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20366/41565.aspx#41565)**

Reply by damir.vadas\_531

Hi John,

THX for your answer.

I’m sorry but looking in Schema compare window, cannot find in any of the tabs your option … Could you tell me tab name to narrow search?

Brg,

Damir

To reply, please reply-all to this email.

[Stop receiving emails](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/t/20366.aspx?subscribe=false) on this subject.

Or [  
Unsubscribe from Toad for Oracle - Beta](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86.aspx?subscribe=false) notifications altogether.

Toad for Oracle - Beta Discussion Forum

[Flag](http://www.toadworld.com/products/toad-for-oracle/toad_for_oracle_beta_program/f/86/p/20366/41565.aspx?AbuseContentId=891fdf73-bb08-416e-87af-8952cc8f5205&AbuseContentTypeId=f586769b-0822-468a-b7f3-a94d480ed9b0&AbuseFlag=true)  
this post as spam/abuse.

![](http://gyk.r.mailjet.com/aaba02cb/52clfr.gif)

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [October 1, 2013, 10:30am UTC](https://forums.toadworld.com/t/compare-schema-based-on-invalid-objects-new-idea/26797/6 "2013-10-01T10:30:11Z")

</div>

John,

THX found it.

Brg

Damir
