Compare objects vs. trailing spaces removal

Peter Kriha

Member²
Hi all,
I compared source and target user by the (excellent!) tool "Compare user objects", then applied the resulting difference script by the command window to the target user and finally repeated the comparison.
Instead of expected message "No differences found" I saw all the differences again.
By a detailed inspection I found that the command window removed all trailing spaces from the source code lines (table comments, column comments, check constraints etc.), which caused the differences.
Does anybody know how to overcome this very unhappy feature?

P.S. I discovered that the Apply SQL button on the Difference Tab of the Compare user objects tool doesn
 
Sorry for omission, here is my configuration:
PLSD version 7.0.3.1094 (MBCS),
Windows XP version 6,0 (build 2600) SP 2,
Oracle Server 10.2.0.2,
Oracle Client 10.2
 
Back
Top