Home » RDBMS Server » Server Utilities » Error with SQL Loader import file in Oracle 10G
Error with SQL Loader import file in Oracle 10G [message #187161] Fri, 11 August 2006 02:56
Messages: 1
Registered: August 2006
Junior Member

Am encountering following error when am trying to import a file using sql loader in Orace 10G.
Value used for ROWS parameter changed from 10000 to 3204
SQL*Loader-297: Invalid syntax or bind variable in SQL string for column INFO_1.
ORA-01756: quoted string not properly terminated

Am able to load the file successfully in Oracle

Have anybody faced similar issue. Any help is greatly appreciated.

Control file and the data file which I am trying to import is attached.
  • Attachment: test.ctl
    (Size: 0.98KB, Downloaded 224 times)
Previous Topic: There's no tkprof utility in my computer
Next Topic: insert records via dump
Goto Forum:

Current Time: Wed Aug 23 12:47:01 CDT 2017

Total time taken to generate the page: 0.23307 seconds