Toad World® Forums

Schema diff claims a table would differ although it is identical

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

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

BR
Dirk

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

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

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

BR
Dirk