5 Replies Latest reply: Feb 19, 2013 4:26 AM by Oracle-Meng RSS

    Created a external table success,  but query it found ORA-29913  KUP-04020

    Oracle-Meng
      CREATE TABLE TB_ALERT_INFO
      ( TEXT VARCHAR2(4000 char)
      )
      ORGANIZATION EXTERNAL
      ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY alertlog
      ACCESS PARAMETERS
      ( records delimited by newline
      nobadfile
      nodiscardfile
      nologfile
      )
      LOCATION
      ( 'alert_spand1.log'
      )
      )
      REJECT LIMIT UNLIMITED;
      /





      ORA-29913: error in executing ODCIEXTTABLEFETCH callout
      ORA-29400: data cartridge error
      KUP-04020: found record longer than buffer size supported, 10485760, in'c:\tmp\'alert_spand1.log'