2 Replies Latest reply: Oct 28, 2012 11:48 AM by 971033 RSS

    Problem in reading fixed width file single column external table

    971033
      Hi,

      I am trying to read a fixed width file that has a single column of 3000 chars.Only the first row is getting read due to spaces in data and not all 3000 chars have valid data.I need the whole 3000 data with spaces also.

      Please find my code below:

      CREATE
      TABLE dump_file_data
      (
      file_data VARCHAR2(3000)
      )
      ORGANIZATION EXTERNAL
      (
      DEFAULT DIRECTORY ext ACCESS PARAMETERS( RECORDS DELIMITED BY NEWLINE
      READSIZE 10048576 LOGFILE ext:'file_data.log' BADFILE ext:'file_data.bad'
      DISCARDFILE ext:'file_data.disc' fields missing field VALUES ARE NULL (
      file_data position(1: 3000) ) ) LOCATION('TEST.DAT')
      );

      Please help.

      TIA,
      Bala