0

I was trying to import data from an oracle database table using a ctl file. Unfortunately, it doesn't work due to a syntax error and, for my efforts, I can't understand why.

SQL code:

sqlldr USERID=user/password, CONTROL=C:\wkt_building001.ctl, LOG=C:\ulcase1.log

file ctl code:

OPTIONS (readsize=20000000, DIRECT=TRUE)
UNRECOVERABLE LOAD DATA
CHARACTERSET UTF8

INFILE 'C:/wkt_building.txt.001'
APPEND
PRESERVE BLANKS
INTO TABLE wkt_building
FIELDS TERMINATED BY '  ' TRAILING NULLCOLS
(
BUILDING_ID,
BUILDING CHAR(100000)
)

error:

org.jkiss.dbeaver.model.sql.DBSQLException: Errore SQL [900] [42000]: ORA-00900: istruzione SQL non valida

at...
    
Caused by: java.sql.SQLSyntaxErrorException: ORA-00900: istruzione SQL non valida


    at ...

Caused by: Error : 900, Position : 0, Sql = sqlldr USERID=user/password, CONTROL=C:\wkt_building001.ctl, LOG=C:\ulcase1.log data=C:\wkt_building.txt.001, OriginalSql = sqlldr USERID=user/password, CONTROL=C:\wkt_building001.ctl, LOG=C:\ulcase1.log data=C:\wkt_building.txt.001, Error Msg = ORA-00900: istruzione SQL non valida


    at ...

thank you in advance

jarlh
  • 42,561
  • 8
  • 45
  • 63
speranza493
  • 21
  • 4
  • `BUILDING CHAR(100000)` ?? try to reduce the size into max limit. try with `BUILDING CHAR(256) -- or less than 4000` – Popeye Dec 14 '20 at 10:53
  • no that's correct I didn't configure the connection with the database so it didn't work, and the command is wrong it is missing: the port the ip address and the database name . Now it works .Anyway thanks for the answer. – speranza493 Dec 15 '20 at 15:00

1 Answers1

0

in the wrong initial command the ip address, the port and the database name are missing, this is the correct version:

  • sqlldr USERID=user/password@10.0.0.116:1521/name_database CONTROL=wkt_face001.ctl LOG=ulcase1.log

Also to configure the connection on cmd follow this guide that uses net menager should have all the steps:

speranza493
  • 21
  • 4