SQL*Plus (MOSC)

MOSC Banner

how to supress large spaces between columns in dump files in fixed length format?

edited Mar 27, 2012 10:13PM in SQL*Plus (MOSC) 5 commentsAnswered
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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center