# Compare Objects dropping schema name

**URL:** <https://forums.toadworld.com/t/compare-objects-dropping-schema-name/9341>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [March 11, 2010, 6:54pm UTC](https://forums.toadworld.com/t/compare-objects-dropping-schema-name/9341 "2010-03-11T18:54:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![RSquires](https://avatars.discourse-cdn.com/v4/letter/r/71c47a/32.png) [@RSquires](https://forums.toadworld.com/u/RSquires)\
**Post date:** [March 11, 2010, 6:54pm UTC](https://forums.toadworld.com/t/compare-objects-dropping-schema-name/9341/1 "2010-03-11T18:54:52Z")

</div>

I was comparing a trigger that is owned by schema A but is for a table owned by schema B. The comparison removed the tables owner so it looked like the table upon which the trigger was based was owned by the owner of the trigger. I didn’t see this initially, copied the script/text from the compare window and then couldn’t figure out why it didn’t work.

Richard

---

<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:** [March 12, 2010, 8:17am UTC](https://forums.toadworld.com/t/compare-objects-dropping-schema-name/9341/2 "2010-03-12T08:17:48Z")

</div>

[Attachment(s) from John Dorlon included below]

Single object compare or schema compare?

If Schema compare,

Go to “Object type specific options” and check “parse for  
schema names”

Go to “misc options” and check “include schema name in  
migration ddl” option
