[Gusdev-rad-issues] Loading RADSAhelp.tab

[Juan C. P. <bi...@ge...>]

Loading RADSAhelp.tab file into radsa.radsahelp table using sqlldr fails to
load all records.  First error was that IS_MANDATORY is set to VARCHAR(4)
when several of the fields in the tab file are size 6.  I also get errors
about the size of DEFINITION.  I increase this size to 2000, and increase
IS_MANDATORY to 6, and I am able to load 233 of the 274 records.  Previously
only 54 loaded.  The IS_MANDATORY error is gone but still get DEFINTION size
limit errors.  I'm looking at the 'bad' rows and am sure that the
DEFINITIONS are not too long, so I assume there is a problem with special
characters perhaps.  (quotes, slashes or double-quotes). My control file for
sqlldr looks like this:

LOAD DATA 
INFILE 'RADSAhelp.tab'
APPEND INTO table RADSA.RADSAHELP
FIELDS TERMINATED BY '  '
trailing nullcols
(
RADSA_HELP_ID,
FORM_NAME,
FIELD_NAME,
ATTRIBUTE_NAME,
IS_MANDATORY,
DEFINITION,
EXAMPLES 
)
 

This is on Oracle 10g.  Perhaps my syntax needs something else for the
control file?

Juan