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 219 times)
Previous Topic: 10g Windows expdp with sys.utl_file error?
Next Topic: SQL loader null and datatype
Goto Forum:
  


Current Time: Fri Dec 02 20:42:24 CST 2016

Total time taken to generate the page: 0.21154 seconds