External Table Newbie Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: External Table Newbie Question

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    External Table Newbie Question

    I have a file that I am trying to load using external table but I am getting an error. It think it is a problem with the newline character.

    I get the following error

    KUP-04023: field start is after end of record


    I have the external table record defined as

    ORGANIZATION EXTERNAL
    ( TYPE ORACLE_LOADER
    DEFAULT DIRECTORY VERIFY_DIR
    ACCESS PARAMETERS
    ( records delimited by newline


    When I do an od -cx command on the file I get

    T
    2c31 3632 3737 3037 3920 4245 4e7c 0a54
    0001020 R | 1 | 2 0 0 4 1 1 | \n
    527c 317c 3230 3034 3131 7c0a
    0001034



    Is this different than the newline defined in my external table???

  2. #2
    Join Date
    Jul 2003
    Posts
    323
    From the 9i db util gd.:

    If the following conditions are true, then you must use hexadecimal digits to identify the delimiter:
    - The character set of the access parameters is different from the character set of the datafile
    - Some characters in the delimiter string cannot be translated into the character set of the datafile

    The hexadecimal digits are converted into bytes, and there is no character set translation performed on the hexadecimal string.

    So if u think it's the newline then guess u'll have to use the hex equivalent of \n (for the newline char!) or try CHARACTERSET US7ASCII?
    ---
    But do post what worked !!




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width