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

Current Time: Sat Oct 22 15:10:17 CDT 2016

Total time taken to generate the page: 0.15685 seconds