Home » RDBMS Server » Server Utilities » SQL Loader - Error
SQL Loader - Error [message #450490] Wed, 07 April 2010 09:25 Go to next message
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
Re: SQL Loader - Error [message #450500 is a reply to message #450490] Wed, 07 April 2010 09:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: SQL Loader - Error [message #450501 is a reply to message #450490] Wed, 07 April 2010 09:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: SQL Loader - Error [message #450502 is a reply to message #450501] Wed, 07 April 2010 09:47 Go to previous messageGo to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Okay Thanks Mahesh and Michael. I will contact Oracle Support.
Re: SQL Loader - Error [message #450538 is a reply to message #450490] Wed, 07 April 2010 14:44 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: SQL Loader - Error [message #450545 is a reply to message #450502] Wed, 07 April 2010 15:54 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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?
Re: SQL Loader - Error [message #476482 is a reply to message #450490] Thu, 23 September 2010 10:10 Go to previous messageGo to next message
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,
Re: SQL Loader - Error [message #476486 is a reply to message #476482] Thu, 23 September 2010 10:14 Go to previous messageGo to next message
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)
Re: SQL Loader - Error [message #476490 is a reply to message #476482] Thu, 23 September 2010 10:20 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: exp/imp of selected oracle view
Next Topic: Oracle Recovery
Goto Forum:
  


Current Time: Thu Mar 28 06:29:21 CDT 2024