Re: [Gusdev-rad-issues] Loading RADSAhelp.tab

[Junmin L. <ju...@pc...>]

Interesting, could you send the whole error message?
Thanks,
---junmin



On Wed, 21 Dec 2005, Juan Carlos Perin wrote:

> 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
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________
> Gusdev-rad-issues mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-rad-issues
>