# Schema diff claims a table would differ although it is identical

**URL:** <https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 28, 2019, 11:44am UTC](https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320 "2019-11-28T11:44:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dirk.mika1](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dirk.mika1/32/16503_2.png) [@dirk.mika1](https://forums.toadworld.com/u/dirk.mika1)\
**Post date:** [November 28, 2019, 11:44am UTC](https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320/1 "2019-11-28T11:44:48Z")

</div>

I have an external table in a schema and when I compare this schema with a template, this table is listed as different. (Differs By "access parameters")  
 ![20](https://global.discourse-cdn.com/quest/original/2X/5/516a7a2c6f593df3a677916bd6e8b8720800885b.png)

However, neither the preview nor the comparison shows a difference.

 ![14](https://global.discourse-cdn.com/quest/original/2X/b/b75b399edf9e5f8e3f759530a9cb5a56884a8ba1.png)

BR  
Dirk

---

<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:** [November 29, 2019, 10:58pm UTC](https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320/2 "2019-11-29T22:58:02Z")

</div>

Maybe it is a whitespace or line feed difference. I'll check on Monday.

---

<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:** [December 2, 2019, 2:38pm UTC](https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320/3 "2019-12-02T14:38:17Z")

</div>

It's not a line feed style difference - CHR(10) vs CHR(13) || CHR(10). Those differences are ignored.

My guess is that it's either due to trailing whitespace, or tabs vs spaces on the lines in the Access Parameter section

That data is in DBA\_EXTERNAL\_TABLES if you want to look for yourself. Please let me know what you find. Seems like this would be a good difference to ignore.

-John

---

<div class="post-metadata">

**Author:** ![dirk.mika1](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dirk.mika1/32/16503_2.png) [@dirk.mika1](https://forums.toadworld.com/u/dirk.mika1)\
**Post date:** [December 9, 2019, 6:28am UTC](https://forums.toadworld.com/t/schema-diff-claims-a-table-would-differ-although-it-is-identical/48320/4 "2019-12-09T06:28:00Z")

</div>

The difference is four additional spaces in the last (empty) line.

 ![21](https://global.discourse-cdn.com/quest/original/2X/2/209b96f628b6ace4f68660a61238cb49f268824f.png)

BR  
Dirk