This discussion is archived
1 Reply Latest reply: Jan 18, 2013 8:42 AM by Srini Chavali-Oracle RSS

External

903224 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points