OraFAQ Forum: Server Utilities » SQL Loader

Home » RDBMS Server » Server Utilities » SQL Loader - Error

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

SQL Loader - Error [message #450490]

Wed, 07 April 2010 09:25

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Hi,

We are getting below error while loading a data in Oracle 10g database using sqlloader.

Error code:

SQL*Loader-704: Internal error: ulnain: error occurred on good insert [-1]

Any help please.

Prashanth

Report message to a moderator

Re: SQL Loader - Error [message #450500 is a reply to message #450490]

Wed, 07 April 2010 09:41

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

Senior Member
Account Moderator

It is an internal error. You need to talk to oracle support.
Atleast provide more information here. Most probably it has to do with your client environment.

Report message to a moderator

Re: SQL Loader - Error [message #450501 is a reply to message #450490]

Wed, 07 April 2010 09:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

SQL*Loader-00704: Internal error: string [number]
Cause: An internal error has occurred.
Action: Make a note of the message and the number, then contact customer support.

Regards
Michel

Report message to a moderator

Re: SQL Loader - Error [message #450502 is a reply to message #450501]

Wed, 07 April 2010 09:47

prashanthgs
Messages: 89
Registered: May 2005
Location: chennai

Member

Okay Thanks Mahesh and Michael. I will contact Oracle Support.

Report message to a moderator

Re: SQL Loader - Error [message #450538 is a reply to message #450490]

Wed, 07 April 2010 14:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

SQL*Loader-704: Internal error: ulnain: error occurred on good insert

Huh, I wonder what error you'd get if insert was bad.

Report message to a moderator

Re: SQL Loader - Error [message #450545 is a reply to message #450502]

Wed, 07 April 2010 15:54

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

Please let us know what Oracle Support says. In the meanwhile, we might be able to help if you would provide more information, such as:

Information needed to reproduce the problem, such as sample data file, control file, create table statement for the table to load the data into, and the exact command you are using to run SQL*Loader.

Are there any triggers on the table that you are laoding into?

Do you get this error any time you try to use SQL*Loader or just on this one load?

What versions and such are your server and client and how are you connecting?

Report message to a moderator

Re: SQL Loader - Error [message #476482 is a reply to message #450490]

Thu, 23 September 2010 10:10

versant
Messages: 2
Registered: September 2010
Location: IBGE/Brazil

Junior Member

We are recieving this erros

SQLLDR-704 [ulnain: error occurred on good i] [18446744073709551615] [] [] [] [] [] []
oci-24550 [3221225477] [Unhandled exception: Code=c00000] [] [] [] [] [] []

When we use rows=1 or rows=2, with the same data file and control file in the same enviroment (client and server), it works fine.

We've already opened a SR in Metalink.

Thanks in advance,

Attachment: load_resumo.ctl
(Size: 8.55KB, Downloaded 1499 times)

Report message to a moderator

Re: SQL Loader - Error [message #476486 is a reply to message #476482]

Thu, 23 September 2010 10:14

versant
Messages: 2
Registered: September 2010
Location: IBGE/Brazil

Junior Member

SQL*Loader 11.1.0.7.0 (Windows 2008 64 bits)
RDBMS 10.2.0.2 (z/Linux SUSE 10)

Report message to a moderator

Re: SQL Loader - Error [message #476490 is a reply to message #476482]

Thu, 23 September 2010 10:20

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

SQL*Loader-00704: Internal error: string [number]
Cause: An internal error has occurred.
Action: Make a note of the message and the number, then contact customer support.

Regards
Michel

Report message to a moderator

Previous Topic:	exp/imp of selected oracle view
Next Topic:	Oracle Recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 09:47:20 CST 2024