OraFAQ Forum: Server Utilities » Error with SQL Loader import file in Oracle 10G

Home » RDBMS Server » Server Utilities » Error with SQL Loader import file in Oracle 10G

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 1300 times)

Report message to a moderator

Previous Topic:	10g Windows expdp with sys.utl_file error?
Next Topic:	SQL loader null and datatype

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 00:29:18 CST 2024