OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Import Error 297

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

Import Error 297 [message #184142]

Tue, 25 July 2006 09:09

fuchsst
Messages: 5
Registered: July 2006

Junior Member

Hello,

hopefully anyone can help me. I recieve the folowing message on trying to load a textfile using the sql-loader:

SQL*Loader-297: Ung�ltige Syntax oder Bindevariable in SQL-Folge f�r Spalte "TEST".
ORA-01756: Anf�hrungsstrich fehlt bei Zeichenfolge

(In English it would something like:
SQL*Loader-297: Invalid syntax or bindvariable in SQL-Statement for column "TEST"
ORA-01756: Quoted string not properly terminated)

We played around with different testfiles and results showed that it is only a problem with textfields (as the second message supposes).
The problem is that the same ctl file and the same client version on another PC works fine, so it seems to be a configuaration problem. Does anyone has an idea what may be the difference and where i can find it?

Thanks in advance...

Report message to a moderator

Re: Import Error 297 [message #184146 is a reply to message #184142]

Tue, 25 July 2006 09:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Could you please post the concerned text file and the ctl file?

Report message to a moderator

Re: Import Error 297 [message #184329 is a reply to message #184146]

Wed, 26 July 2006 03:18

fuchsst
Messages: 5
Registered: July 2006

Junior Member

attached the simple testfile
it works on a colleagues desktop but not on mine...

Attachment: Test.CTL
(Size: 0.20KB, Downloaded 1356 times)

[Updated on: Wed, 26 July 2006 03:21]

Report message to a moderator

Re: Import Error 297 [message #184331 is a reply to message #184142]

Wed, 26 July 2006 03:21

fuchsst
Messages: 5
Registered: July 2006

Junior Member

No Message Body

Attachment: test.txt
(Size: 0.05KB, Downloaded 1346 times)

Report message to a moderator

Re: Import Error 297 [message #184372 is a reply to message #184331]

Wed, 26 July 2006 06:31

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Works good for me too (9.2.0.4, Sun8, Sunblade100).
In your case, are the OS/Oracle version different in those machines?

Report message to a moderator

Re: Import Error 297 [message #184390 is a reply to message #184372]

Wed, 26 July 2006 07:06

fuchsst
Messages: 5
Registered: July 2006

Junior Member

there are no fundamental differences both are win2k with oracle10g-client.
any idea where or what may be configured differently on the oracle client?

Report message to a moderator

Re: Import Error 297 [message #184410 is a reply to message #184390]

Wed, 26 July 2006 08:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There are a few known bugs in 10gR2 that are very unhappy with sqlldr.
Could you try something like this?

LOAD DATA
  INFILE  'test.data'
  Append
INTO TABLE test
  REENABLE DISABLED_CONSTRAINTS
  WHEN (1) = '5'
  (   
  TEST POSITION (2:10) "trim(:TEST)||'(RX)' "
  )

Report message to a moderator

Re: Import Error 297 [message #184444 is a reply to message #184410]

Wed, 26 July 2006 10:07

fuchsst
Messages: 5
Registered: July 2006

Junior Member

quite curious...

i changed the testfile and it worked...thanks
do you know or guess what was the wrong position? or is there a list of known problems with sqlldr/10gR2?

Report message to a moderator

Re: Import Error 297 [message #184449 is a reply to message #184444]

Wed, 26 July 2006 10:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

The way the character strings are treated.
>>is there a list of known problems with sqlldr/10gR2?
That would be cool.
Check metalink.

Report message to a moderator

Previous Topic:	import problem with oracle 10.1.0 on Win2K
Next Topic:	SQL * Loader issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 07:51:19 CST 2024