1 Reply Latest reply: Jan 18, 2013 10:42 AM by Srini Chavali-Oracle RSS

    External

    903224
      whats wrong with the below script , its rejecting the records set for CLOB column,pls help.
      CREATE TABLE TTEXT (
        C1        CHAR(300),
        C2 CHAR(300),
        C3 CHAR(300),
        C4 CLOB,
        C5 CHAR(300)
      )
      ORGANIZATION EXTERNAL
      (
        TYPE ORACLE_LOADER
        DEFAULT DIRECTORY DIR
        ACCESS PARAMETERS
        (
          RECORDS DELIMITED BY NEWLINE
          FIELDS TERMINATED BY ','
          MISSING FIELD VALUES ARE NULL
          (
            C1 CHAR(300),
        C2 CHAR(300),
        C3 CHAR(300),
        clob_filename CHAR(30000),
        C5 CHAR(300)
          )
          COLUMN TRANSFORMS (C4 FROM LOBFILE (clob_filename) FROM (DIR) CLOB)
        )
        LOCATION ('File.csv')
      )
      PARALLEL 2
      REJECT LIMIT UNLIMITED