how to supress large spaces between columns in dump files in fixed length format?
We upgraded oracle to 11g and character set to UNOCODE and our scripts generating dump files in fixed length format started producing large spaces between columns. The data is correct and the length of it is correct as well.if we switch to delimited format all looks ok and there no unwanted spaces between columns. Dump files are generated from sqlplus and whether from the server or from the local sqlplus connected to the new db we have this problem.
old db:
OS Linux 5 x86-64
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
char set WE8ISO8859P1
new db:
old db:
OS Linux 5 x86-64
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
char set WE8ISO8859P1
new db:
0