Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2013
    Posts
    19

    Unanswered: Oracle External Table, how to insert incomplete data [ Help !!!! ]

    Hi All,

    Is anyone can guide how to solve below issue?
    I want to insert all the record into external table.

    Appreciate anyone can help. Thanks.


    Problem:
    Using Oracle External Table, hit error KUP-04018: partial record at end of file.


    Data File:
    H20131217
    DMee Maggie 123Food
    DMilo 456Drink
    T00002



    CREATE TABLE PRODUCT
    (
    REC_IND CHAR(1),
    PRD_NM VARCHAR(50),
    PRD_CD VARCHAR2(10),
    PRD_DSCP VARCHAR2(50)
    )
    ORGANIZATION EXTERNAL
    (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY EXT_DIR
    ACCESS PARAMETERS
    (
    RECORDS FIXED 65 FIELDS (
    REC_IND CHAR(1),
    PRD_NM CHAR(30),
    PRD_CD CHAR(3),
    PRD_DSCP CHAR(30))
    )
    LOCATION ('prd.dat')
    );

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    You are possibly missing a line feed (chr(10)) at the last line of the file.
    Also, you may want to add the "MISSING FIELD VALUES ARE NULL" option to the create table ddl.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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