4 Replies Latest reply on Jan 22, 2016 8:24 PM by rp0428

    External Tables loosing Records

    siegwin.port

      Hi,

      I tried to get records from external table. The table is defined as 1 string (CLOB)

      The first 6 Bytes are numeric and should show the sequence number.

      When I create the table like

      create table zug_l_ext

      (zugl_zeile clob)

      ORGANIZATION EXTERNAL

          ( TYPE ORACLE_LOADER

            DEFAULT DIRECTORY "DATEIEN_DIR"

            ACCESS PARAMETERS

            ( RECORDS DELIMITED BY NEWLINE

          CHARACTERSET WE8ISO8859P15

          LOGFILE DATEIEN_DIR: 'zug_l_EXT.LOG' )

          LOCATION

             ( "DATEIEN_DIR":'ERG_zl.txt'

             )

          )

         REJECT LIMIT UNLIMITED ;

       

      I can read this records but I cannot get 250000 records, only 190000 and there are missing records. The min record number is not 1 (in the original data it is 1), it is 4 (records 1-3 are missing). And ther are a lot of gaps in the selecte records

      What did I wrong?

      Regards

      Siegwin