1. Forum
  2. Usenet
  3. COMP.DATABASES.ORACLE.SER

  • Facing Issue like SQL*Loader-350: Syntax error at line 1. Expecting key

    From Vaanmathi M@21:1/5 to All on Thu May 6 03:47:46 2021
    SQL*Loader-350: Syntax error at line 1.
    Expecting keyword INTO, found end of file.

    OPTIONS(ROWS=1000,DIRECT=TRUE)
    LOAD DATA
    CHARACTERSET UTF8
    INFILE '%INFILE%'
    TRUNCATE
    INTO table tableName
    FIELDS TERMINATED BY "~"
    TRAILING NULLCOLS
    (
    col1 CHAR(4000),
    col2 CHAR(4000),
    .
    .
    .
    col140 CHAR(4000)
    )

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)