用以下条件定义的外部表将数据从文件加载到表。这在prod中运行很长时间没有问题。

We started having this issue for below field
  **KUP-04021: field formatting error for field column3
    KUP-04026: field too long for datatype**

数据的列长度约为625个字符，在定义为varchar（1300字节）的外部表中为column3

The value below is causing the issue 
    (170KB ACCT SHR $0.00003/KB $0),48553(170KB ACCT SHR $0.00003/KB $0),68872(170KB ACCT SHR $0.00003/KB $0),70421(170KB ACCT SHR $0.00003/KB $0),73578(170KB ACCT SHR $0.00003/KB $0),75622(170KB ACCT SHR $0.00003/KB $0),75706(170KB ACCT SHR $0.00003/KB $0),75837(170KB ACCT SHR $0.00003/KB $0),75875(170KB ACCT SHR $0.00003/KB $0),76193(170KB ACCT SHR $0.00003/KB $0),81896(170KB ACCT SHR $0.00003/KB $0),83905(170KB ACCT SHR $0.00003/KB $0),84206(170KB ACCT SHR $0.00003/KB $0),84840(170KB ACCT SHR $0.00003/KB $0),87215(170KB ACCT SHR $0.00003/KB $0),662(170KB ACCT SHR $0.00003/KB $0),732(170KB ACCT SHR $0.00003/KB $0)

外部表定义，该定义当前已就位，并且存在上述数据加载问题。

CREATE TABLE DADM.LOAD_EXT
(
    COLUMN1                         VARCHAR2(200 BYTE),
    COLUMN2                         VARCHAR2(26   BYTE),
    COLUMN3                         VARCHAR2(1300 BYTE),
    COLUMN4                         VARCHAR2(30   BYTE)

)
ORGANIZATION EXTERNAL
  (  TYPE ORACLE_LOADER
     DEFAULT DIRECTORY EXT_DATA_DIR
     ACCESS PARAMETERS 
       ( RECORDS DELIMITED BY NEWLINE
      BADFILE EXT_BAD_DIR:'file.bad'
      LOGFILE EXT_LOG_DIR:'file.log'
      FIELDS TERMINATED BY '|' LRTRIM
      MISSING FIELD VALUES ARE NULL
      REJECT ROWS WITH ALL NULL FIELDS
      NULLIF = "null"
      (
        COLUMN1, 
        COLUMN2 ,
        COLUMN3, 
        COLUMN4         
        )
     )
     LOCATION (EXT_DATA_DIR:'extract_file_.dat_tr')
  )
REJECT LIMIT UNLIMITED
/

上述外部表的数据
l-5772559 |无124；48526（170kb账户shr$0.00003/kb$0.00003/kb$0.00003/kb$0，48553（170kb账户shr$0.00003/kb$0，170872（170kb账户shr$0.00003/kb$0，170kb账户shr$0.00003/kb$0），48553（48553（170kbb账户shr$0.00003/kb$0.00003/kb$0），6855555555553（170kb账户shr$0.00003/kb$0.00003/kb$0.0003/kb$0）的686（68706（170kbb账户shr账户shr$0.00003/0.00003/kb0.00003/kb3/kb$0.0003/kb$0.0003/kb$0.0003/kb$0，每kb$0），76193（170kb账户shr$0.00003/kb$0）、81896（170kb账户shr$0.00003/kb$0）、83905（170kb账户shr$0.00003/kb$0）、84206（170kb账户shr$0.00003/kb$0）、84840（170kb账户shr$0.00003/kb$0）、87215（170kb账户shr$0.00003/kb$0）、662（170kb账户shr$0.00003/kb$0）、732（170kb账户shr$0.00003/kb$0）| 00058