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
skamath
Messages: 1
Registered: August 2006
Junior Member
Hi,

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 8.1.7.4

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